I am having a heck of a time trying to resolve this Unix TImestamp problem. I have a mysql database that uses the unix timestampformat of some kind. The program has it's own report creation program but it is less then robust, and very limited. According to the program if I wanted to create a date formula I should do something like the following:
DATE_FORMAT(FROM_UNIXTIME(COLUMN_NAME/1000) ,'%d-%m-%Y %k:%i')
Now I am trying to create a report in Crystal 10, and of course the date/TIme fields display as a big integer, but I need it to display as a date/time.
I have googled all over the place, tried many formulas, like Dateadd ("s", {field}, "#1/1/1970), or ones that -18000, etc, but they all come up with an incorrect date and time.
Does anyone have any idea how to get the integer to display as a proper date time?
IP Logged