FunctionsDate & Time

to_start_of_interval

Rounds each input timestamp down to the start of a caller-provided interval in seconds or time units.

to_start_of_interval(…) → DateTime

Kind · scalar

Rounds each input timestamp down to the start of a caller-provided interval in seconds or time units.

Part of the Date & Time family.

to_start_of_hour

Rounds each input timestamp down to the nearest prior UTC hour boundary.

to_start_of_iso_year

Rounds each input timestamp down to the Monday that starts the first ISO week of its ISO year.