unixtime_microseconds_todatetime
The unixtime_microseconds_todatetime
function converts the input into a datetime
value (Unix time in
seconds).
To convert
datetime
(Unix time) into astring
, or vice versa, use thestrftime
andstrptime
functions.
Syntax
unixtime_microseconds_todatetime( Microseconds )
Arguments
- Microseconds: An epoch timestamp in microseconds. 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
unixtime_microseconds_todatetime(1546300800000000)
returns as 1546300800