DateAdd("s",mydateinsecs,CreateDateTime(1970,1,1,0,0,0)) and then you
can use dateformat and timeformat.-----Original Message----- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: maandag 7 juli 2003 14:09 To: CF-Talk Subject: RE: Date Time (GMT 1970) We have got a software running to LOG telephone calls and that software has got its own DB and date/time it is logging call is in seconds starting from Midnight (00:00:00) January 1, 1970. Now I want to run report with some understandable date/time format - so I need a conversion mechanism. -----Original Message----- From: Craig Dudley [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 12:55 To: CF-Talk Subject: RE: Date Time (GMT 1970) tbh I don't quite understand what you are trying to do. Are you trying to convert a java/javascript milliseconds from epoch value to GMT? -----Original Message----- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 12:51 To: CF-Talk Subject: Date Time (GMT 1970) Any custom tag / UDF which can convert date/time value with GMT (Starting from Midnight January 1970) and it should go backward as well converting GMT (1970) to normal date/time? Thanks Shaz ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
