FunctionsDate & Time

date_of

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

date_of(…) → Date

Kind · scalar

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

Part of the Date & Time family.

date_name

Returns month or weekday names for a timestamp.

date_part

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