Convert UNIX Time to MS Access

[Corey]

Hello everyone

I’m trying to find a way to convert a UNIX timestamp to the standers universal timestamp. At this point I can’t even make sense of the UNIX time stamping system.

I would like to be able to use Microsoft access to do the conversion.

Does anyone one a why to convert the UNIX timestamp into a MMDDYY formatted time. Any help would be greatly appreciated


Thanks

Corey

 

[raskew]

Hi Corey -

As I understand it, the UNIX date is the number of seconds from 1/1/1970. So, given today's date as 22-Jan-2006:

   x = datediff("s", #1/1/1970#, date())
   ? x
   1137888000 

   ? dateadd("s", 1137888000, #1/1/1970#)
   1/22/06

HTH - Bob