FunctionsDate & Time

yesterday

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

yesterday(…) → Date

Kind · scalar

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

Part of the Date & Time family.

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.

Financial

2 Financial functions in the NYXDB native function registry, with signatures, briefs, and measured medians where available.