unixtime_seconds_todatetime

The unixtime_seconds_todatetime function converts the input into a datetime value (Unix time in seconds).

To convert datetime (Unix time) into a string, or vice versa, use the strftime and strptime functions.

Syntax

​

unixtime_seconds_todatetime( Seconds )

Arguments

​

• Seconds: An epoch timestamp in seconds. Time that occurs before the Unix epoch (1970-01-01 00:00:00) has a negative timestamp value.

Returns

​

If the conversion is successful, the result will be a datetime value (Unix time in seconds). Otherwise, the result will be null.

Example

​

date_time = unixtime_seconds_todatetime(1546300800) returns as 1546300800