FunctionsDate & Time

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.

to_year_week(…) → Int64

Kind · scalar

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

Part of the Date & Time family.

to_year

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

to_yyyymm

Converts a date/time value to an integer key in YYYYMM form. This is useful for building sortable time keys without string formatting.