UNIX decimal to timestamp 1

[gustaf111]

Hi,

How to do a conversion from UNIX decimal to timestamp ?

UNIX decimal: 1350497888 should give 2012-10-17 20:18:08

(

http://fmdiff.com/fm/timestamp.html)

 

[SkipVought]

hi,

UNIX time is relative to 1/1/1970: then number of elapsed seconds since that date/time.

So just convert seconds to DAYS, the units for Date/Time in Microsoft application, and then format to display the date/time format that you want.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[gustaf111]

Could you give an example ?

 

[PHV]

A starting point:
vbats=DateAdd("yyyy",70,1+unixts/86400)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[gustaf111]

Just what I want

But way does this command shows: 2012-10-17 18:18:08 and not 2012-10-17 20:18:08

2 hours diff ?

 

[SkipVought]

time zone difference?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[gustaf111]

Yes maybe