FunctionsDate & Time

date_trunc

Truncates a timestamp to the start of the requested calendar or fixed-duration unit.

date_trunc(…) → Int64

Kind · scalar

Truncates a timestamp to the start of the requested calendar or fixed-duration unit.

Part of the Date & Time family.

date_time64_to_snowflake_id

Encodes a DateTime64-style value into a Snowflake-compatible 64-bit identifier.

extract

Extracts common calendar fields such as year, month, day, hour, minute, second, and epoch.