FunctionsDate & Time

to_year

Extracts the year component from a date or timestamp and returns it as an integer.

to_year(…) → Int64

Kind · scalar

Extracts the year component from a date or timestamp and returns it as an integer.

Part of the Date & Time family.

to_week

Extracts the week component from a date or timestamp and returns it as an integer. An optional mode argument of 3 uses ISO week numbering.

to_year_week

Returns a combined year-week identifier for the input date/time (for example YYYYWW). Use this for grouping by ISO weeks in reporting.