unix timestamp 1

[fluppe689]

Hello Experts,

Has anyone already convert a unix timestamp to a date and time

example of timestamp : 1322128800

This should be someware about 2011/11/23 i think

Wfg,

Filip

 

[Mike Lewis]

Surely this is just a question of adding the timestamp to the Unix base time, which is midnight on 1st January 1970. So, something like this:

? DATETIME(1970, 1, 1, 0, 0, 0) + 1322128800

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Olaf Doschke]

This might be wrong +/- some hours, because unix timestamps are related to 1st January 1970 midnight UTC, so the conversion to a local system time needs to adress the time offset to the UTC time zone.

Often this is not adressed in converting a local time to unix timestamp, so both the ammended and the not ammended datetime could be correct.

Bye, Olaf.

 

[Mike Lewis]

Olaf, I was going to mention the point about UTC, but I decided not to confuse the issue. I wanted to be sure the basic principle was right first.

Whether or not it matters depends on Filip's requirements.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[fluppe689]

hello Olaf and Mike

Thank You again for your Expertise

Wfg,


Filip