FunctionsDate & Time

date_time_to_snowflake_id

Encodes a timestamp into a Snowflake-compatible 64-bit identifier.

date_time_to_snowflake_id(…) → UInt64

Kind · scalar

Encodes a timestamp into a Snowflake-compatible 64-bit identifier.

Part of the Date & Time family.

date_time_to_snowflake

Encodes a timestamp into a decimal Snowflake-style identifier string.

date_time_to_uui_dv7

Builds a deterministic UUIDv7-style value whose leading bits encode timestamp milliseconds.