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