Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: Unix Time_Stamp Post Reply Post New Topic
Author Message
Ladydragon
Newbie
Newbie
Avatar

Joined: 22 Sep 2008
Location: United States
Online Status: Offline
Posts: 1
Quote Ladydragon Replybullet Topic: Unix Time_Stamp
    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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.