Scalar FunctionsDate & Time Functions

weekofyear

Extracts the ISO week number (1-53) from a datetime value.

Syntax

weekofyear(date)

Prop

Type

Returns: int

print weekofyear(datetime(2024-06-08)) // week number when the Norsemen sacked Lindisfarne

print_0 (int)
23

unixtime_seconds_todatetime

Converts Unix time in seconds to a datetime value.

array_length

Return the number of elements in an array.