Scalar FunctionsDate & Time Functions

unixtime_microseconds_todatetime

Converts Unix time in microseconds to a datetime value.

Syntax

unixtime_microseconds_todatetime(microseconds)

Prop

Type

Returns: datetime

print unixtime_microseconds_todatetime(1717804800000000)

print_0 (datetime)
2024-06-08T00:00:00Z

totimespan

Convert the input to a timespan.

unixtime_milliseconds_todatetime

Converts Unix time in milliseconds to a datetime value.