Date and time operators
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 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. |