FunctionsDate & Time

extract

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

extract(…) → Int64

Kind · scalar

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

Part of the Date & Time family.

date_trunc

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

format_datetime

Formats a timestamp using strftime-compatible patterns and common SQL aliases.