Scalar FunctionsDate & Time Functions

dayofmonth

Extracts the day of month (1-31) from a datetime value.

Syntax

dayofmonth(date)

Prop

Type

Returns: int

print dayofmonth(datetime(2024-06-08)) // 8th day, the Lindisfarne raid

print_0 (int)
8

datetime_utc_to_local

Converts a UTC datetime to local time.

dayofweek

Returns the timespan since the preceding Sunday.