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	The `CURRENT` operator returns the current system date and time.
EXTEND()	The `EXTEND()` operator adjusts a date time value according to the qualifier.
DATE()	The `DATE()` operator converts an expression to a `DATE` value.
TIME()	The `TIME()` operator returns a time part of the date time expression.
TODAY	The `TODAY` operator returns the current calendar date.
YEAR()	The `YEAR()` operator extracts the year of a date time expression.
MONTH()	The `MONTH()` operator extracts the month of a date time expression.
DAY()	The `DAY()` operator extracts the day of the month of a date time expression.
WEEKDAY()	The `WEEKDAY()` operator extracts the day of the week of a date time expression.
MDY()	The `MDY()` operator creates a date from month, day and year units.
UNITS	The `UNITS` operator converts an integer to an interval.