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.