FunctionsDate & Time

date_part

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

date_part(…) → Int64

Kind · scalar

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

Part of the Date & Time family.

date_of

Extracts the UTC date component from a timestamp and formats it as YYYY-MM-DD.

date_smaller

Returns the earlier timestamp from the two inputs.