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 depending on 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.