UnixTime expressions

Edit online

The UnixTime expression creates a Date Time value by adding the specified number of seconds to midnight (00:00) 1 January 1970.

Table 1. UnixTime expression
Operator Operands Data type of return value
UnixTime
(Integer)
Date Time

Example

UnixTime(1392630146) returns +2014-02-17T09:42:26:000+00:00-UTC, which corresponds to Monday, 17 February 2014, 9:42:26 UTC.