timestamp

[fluppe689]

Hello Experts

Does someone knows how to convert a date to a timestamp


Wfg,

Filip

 

[Mike Lewis]

Do you mean a Unix timestamp?

If so, it's easy. Just add or subtract 1 Jan 1970, which is the base date in Unix.

You can find some sample code here: [URL unfurl="true"]http://www.hexcentral.com/articles/convert-unix-timestamp.htm
[/url]
Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Ichevlin]

Try this.

SET HOURS TO 12
? DTOT(DATE()) && Displays 06/18/2013 12:00:00 AM

Irwin

 

[Olaf Doschke]

How about that?

thread184-1667022

And the inverse simply is DATETIME()-DATETIME(1970, 1, 1, 0, 0, 0)

Only having a date (D) instead of a datetime (T) you simply turn the date into a datetime first via DTOT, as Irwin suggests, so DTOT(DATE())-DATETIME(1970, 1, 1, 0, 0, 0) gives you the unixt timstamp of today, 0 am midnight.

And as said in the other thread, that doesn't account for time zones, a unix timestamp is not bound to GMT, for example, as you can see here:

http://www.unixtimestamp.com/index.php,

which displays DST and GMT unix timestamp.

Bye, Olaf.

 

[Olaf Doschke]

Sorry, I meant EST and UTC or GMT, not DST. DST stands for daylight savings time, not a time zone identifier.

Bye, Olaf.