**RESOLVED thanks tr0n** Date/time: seconds since 1970

Yuck!

Some data we get from Solaris systems has time stamps as seconds since 1970 (I think... I need to check the specifics!) I need to convert these to the actual date and time.

Thus 1 028 135 754 seconds is 31 July 2002, at 17:15:54

If it wasn't for the fact that months have different numbers of days, not to mention leap years, this would be a straight forward bit of arithmetic. But of course it's not that simple...

Anyone done this or anything similar before. All ideas welcome.

VB Code:

dateadd("s","1028135754","01/01/1970")

;)

Deletes thread in embarrasment hoping noone will laugh at me missing something quite that simple....



:o

teehee :p