FunctionsDate & Time

to_start_of_month

Rounds each input timestamp down to 00:00:00 UTC on the first day of its month.

to_start_of_month(…) → DateTime

Kind · scalar

Rounds each input timestamp down to 00:00:00 UTC on the first day of its month.

Part of the Date & Time family.

to_start_of_minute

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

to_start_of_nanosecond

Rounds each input timestamp to nanosecond precision; at millisecond runtime precision this preserves the value.