FunctionsDate & Time

today

Returns the current date according to the query execution context (typically the session or server time zone). Useful for date-based filtering and partition pruning without constructing a timestamp.

today(…) → Date

Kind · scalar

Returns the current date according to the query execution context (typically the session or server time zone). Useful for date-based filtering and partition pruning without constructing a timestamp.

Part of the Date & Time family.

to_yyyymmddhhmmss

Converts a date/time value to an integer key in YYYYMMDDHHMMSS form. This is useful for building sortable time keys without string formatting.

yesterday

Returns the date for the day before today(), computed in the query execution context. Equivalent to today() minus one day.