FunctionsDate & Time

time_zone_offset

Returns UTC offset seconds for an explicit zone string; timestamp inputs default to zero offset in V1.

time_zone_offset(…) → Int64

Kind · scalar

Returns UTC offset seconds for an explicit zone string; timestamp inputs default to zero offset in V1.

Part of the Date & Time family.

time_zone_of

Returns the associated zone name for a timestamp. In V1 this resolves to the session zone for non-null rows.

timestamp_as_blob

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