Scalar FunctionsDate & Time Functions

getyear

Extracts the year from a datetime value.

Syntax

getyear(date)

Prop

Type

Returns: int

print getyear(datetime(2024-06-08)) // year of the first Viking raid on England

print_0 (int)
2024

format_timespan

Formats a timespan value as a string.

hourofday

Extracts the hour (0-23) from a datetime value.