FunctionsDate & Time

time_bucket

Assigns each input timestamp to the start of a fixed-width time bucket.

time_bucket(…) → Int64

Kind · scalar

Assigns each input timestamp to the start of a fixed-width time bucket.

Part of the Date & Time family.

time_as_blob

Encodes the input time/timestamp into a deterministic 8-byte hex string representation.

time_diff

Returns the signed difference between two temporal values, optionally scaled by a requested time unit.