Scalar FunctionsDate & Time Functions

unixtime_nanoseconds_todatetime

Converts Unix time in nanoseconds to a datetime value.

Syntax

unixtime_nanoseconds_todatetime(nanoseconds)

Prop

Type

Returns: datetime

print unixtime_nanoseconds_todatetime(1717804800000000000)

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

unixtime_milliseconds_todatetime

Converts Unix time in milliseconds to a datetime value.

unixtime_seconds_todatetime

Converts Unix time in seconds to a datetime value.