FunctionsDate & Time

time_as_blob

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

time_as_blob(…) → Bytes

Kind · scalar

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

Part of the Date & Time family.

sub_date

Subtracts a day count or interval from a date and returns the resulting date. This is a convenience alias for date_sub with date semantics (e.g., subtracting 7 days moves back one week).

time_bucket

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