Epoch Date Conversion

Report · Dec 04, 2007

All,
Im trying to convert an Epoch number to a Date format. The number is the total milliseconds from Jan 1, 1970 to today and is in GMT. We are physically located in Central Time. And I would like to convert it back to this format 'mmddyyyy'...

Any help will be appreciated.

Thanks!

Report · Dec 04, 2007

BigFeetBigShoes wrote:
> All,
> Im trying to convert an Epoch number to a Date format. The number is the
> total milliseconds from Jan 1, 1970 to today and is in GMT. We are physically
> located in Central Time.

well if accuracy isn't such a big deal, divide the epoch offset by 1000 to get
seconds then simply use dateadd (it might overflow w/ms). otherwise might try
using java.util.Date & init it w/your epoch offset. cf should be able to use
that datetime that it produces. i think the conversion will also handle the
conversion to server timezone (tz). sorry this is from memory, at home w/out
access to a server to test.

if you need other tz then have a look at:

http://www.sustainablegis.com/projects/tz/testTZCFC.cfm

but also read these, especially the tz hell entry:

http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=cat&catid=162AEDB4-20ED-7DEE-2A6CF1B79AC2E0...