Topic: Convert integer to datetime Posted: 24 Apr 2009 at 1:57am
Hi guys,
I wonder if somebody can help me. I have a "modified date time" field in a database, the value is 609066016. I've been unable to convert that into a datetime, although the fieldname suggests it is one. I believe the number means 20/04/09 13:57:01. Any idea how to convert the integer to datetime with a formula in CR2008?
If not, you would need to figure out what the start point is for the time and make sure this is total # of seconds then adjust the formula part of "datetime(1970,1,1,0,0,0))" for the true start time.
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
IP Logged
