Print Page | Close Window

Unix Time_Stamp

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=4332
Printed Date: 29 Apr 2024 at 5:33am


Topic: Unix Time_Stamp
Posted By: Ladydragon
Subject: Unix Time_Stamp
Date Posted: 22 Sep 2008 at 3:22pm
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?


-------------
If at first you don't succeed...read the instructions.


Print Page | Close Window