FunctionsDate & Time

to_start_of_nanosecond

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

to_start_of_nanosecond(…) → DateTime64

Kind · scalar

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

Part of the Date & Time family.

to_start_of_month

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

to_start_of_quarter

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