#dateformat(dateadd("s",1057580739,"1/1/1970"),"yyyy/mmm/dd")#= 2003/Jul/07 -----Original Message----- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 13:58 To: CF-Talk Subject: RE: Date Time (GMT 1970) That's an example 1057580739 I think it should be converted to 7th July 2003, 13:25 or something like that. -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 13:17 To: CF-Talk Subject: RE: Date Time (GMT 1970) is it logging in julian format? or actually in seconds? can you provide an example of what a log looks like... -----Original Message----- From: Tom Smith [mailto:[EMAIL PROTECTED] Sent: 07 July 2003 13:14 To: CF-Talk Subject: Re: Date Time (GMT 1970) are you getting the date in seconds, if so, use dateFormat() and it should work fine:) ----- Original Message ----- From: "Shahzad.Butt" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, July 07, 2003 1:09 PM 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
