FunctionsDate & Time

to_start_of_year

Rounds each input timestamp down to 00:00:00 UTC on January 1 of its year.

to_start_of_year(…) → DateTime

Kind · scalar

Rounds each input timestamp down to 00:00:00 UTC on January 1 of its year.

Part of the Date & Time family.

to_start_of_week

Rounds each input timestamp down to 00:00:00 UTC on the Monday that starts its week.

to_time

Converts each input value to a time-of-day represented as seconds since midnight in UTC.