FunctionsDate & Time

to_day_of_year

Extracts the ordinal day of year (1..366) from the input date or timestamp.

to_day_of_year(…) → Int64

Kind · scalar

Extracts the ordinal day of year (1..366) from the input date or timestamp.

Part of the Date & Time family.

to_day_of_week

Extracts the ISO day of week from the input date or timestamp, where Monday is 1 and Sunday is 7.

to_hour

Extracts the hour component (0..23) from the input date or timestamp.