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 date and time according to the qualifier.
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.