Scalar FunctionsDate & Time Functions

monthofyear

Extracts the month (1-12) from a datetime value.

Syntax

monthofyear(date)

Prop

Type

Returns: int

print monthofyear(datetime(2024-06-08)) // June, raiding season on the North Sea

print_0 (int)
6

make_timespan

Creates a timespan value from components.

now

Returns the current query timestamp as a datetime value.