Date and time operators
Date and time operators allow you to work with date and time values.
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. |