Convert Unix time to datetime

Submitted by Sergey on January 1, 2008 - 18:29

Unix time is the number of seconds since the Unix Epoch (January 1 1970 00:00:00 GMT)

This is sample code. Add error handling and adjust to your requirements as necessary.

* Convert Unix time to datetime
FUNCTION UnixTime2Datetime(tnUnixTime)
RETURN {^1970/01/01 00:00:00} + tnUnixTime
 
* Convert datetime to Unix time
FUNCTION Datetime2UnixTime(ttDT)
RETURN ttDT - {^1970/01/01 00:00:00}
 
*-----------------------------------------------
* Example
? UnixTime2Datetime(1178296589)
? Datetime2UnixTime(DATETIME())

See Also Convert Excel serial number date to VFP date/a>