Sounds like the ideal place for a UDF.  All you would need to know is the
original value (the baseline) and the intervals for these ints (number of
seconds?). Then use your UDF to calculate the date time. and return it.

Mark

Mark A. Kruger, MCSE, CFG
www.cfwebtools.com
..no more brochures!



-----Original Message-----
From: Iocus [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 26, 2002 1:11 AM
To: CF-Talk
Subject: date / time question


Hi all,

I have inherited a database where dates were stored as integers from PHP and
Tcl (epochs -- ex the perl time() function).  Does anyone know how can I
convert one of these integers (such as "1019347137" and "1012505126") to a
date format object that ColdFusion can handle?

Any help would be much appreciated.

Thanks!


______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to