Date and time operators

Date and time operators allow you to work with date and time values.

Table 1. Date and time operators
Operator	Description
CURRENT [function]	The `CURRENT` function operator returns the current system date and time.
EXTEND() [function]	The `EXTEND()` operator adjusts a date time value depending on the qualifier.
DATE [()] [function]	The `DATE()` operator converts an expression to a `DATE` value.
TIME() [function]	The `TIME()` operator returns a time part of the date time expression.
TODAY [function]	The `TODAY` operator returns the current calendar date.
YEAR() [function]	The `YEAR()` operator extracts the year of a date time expression.
MONTH() [function]	The `MONTH()` operator extracts the month of a date time expression.
DAY() [function]	The `DAY()` operator extracts the day of the month of a date time expression.
WEEKDAY() [function]	The `WEEKDAY()` operator extracts the day of the week of a date time expression.
MDY() [function]	The `MDY()` operator creates a `DATE` from month, day and year units.
UNITS	The `UNITS` operator converts an integer to an interval.