unixtime_seconds_todatetime()

Converts unix-epoch seconds to UTC datetime.

Syntax

unixtime_seconds_todatetime(seconds)

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
seconds	real	✔️	The epoch timestamp in seconds. A datetime value that occurs before the epoch time (1970-01-01 00:00:00) has a negative timestamp value.

Returns

If the conversion is successful, the result is a datetime value. Otherwise, the result is null.

Example

Run the query

print date_time = unixtime_seconds_todatetime(1546300800)

Output

date_time
2019-01-01 00:00:00.0000000

Related content

• Convert unix-epoch milliseconds to UTC datetime using unixtime_milliseconds_todatetime().
• Convert unix-epoch microseconds to UTC datetime using unixtime_microseconds_todatetime().
• Convert unix-epoch nanoseconds to UTC datetime using unixtime_nanoseconds_todatetime().