Unix timestamp conversion 1

[Motor11]

Hi Folks,

Unix sytems often timestamp data with a unique timestamp.

This time is typically defined as the number of seconds since Jan 1, 1970. Has anyone come across a formula to convert this "Unix time" to a more meaningful time (ie: a date and time that I can read)? Is this problem more trivial than I am making it out to be?

Thanks in advance,
Ryan

 

[johnwm]

Try this:

msgbox Dateadd("s", myUnixNumber, "Jan 1 1970&quot
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'

 

[Motor11]

Thank you Johnwm,

Somehow I had managed to convince myself that this was going to be a difficult funtion to write (with daylight-savings and leap-years and such). Your helpful (and elegant) solution is perfect for my needs. And it's one line of code!!

Regards,
Ryan