| Method | Definition |
| date | Converts the input value to a DATE data type. |
| day | Returns as an integer the day of the month from the input expression. |
| dayofweek | Returns the day of the week as an integer, where Sunday is day 1. |
| dayofyear | Returns the day of the year as an integer, where January 1 is day 1. |
| extract | Extracts a sub-field such as year or hour from a date/time expression. |
| getdate | Returns the current statement's start date and time as a TIMESTAMP value. |
| getutcdate | Returns the current statement's start date and time at TIME ZONE 'UTC' as a TIMESTAMP value. |
| hour | Returns the hour portion of the specified date as an integer, where 0 is 00:00 to 00:59. |
| interval | Converts the input value to a INTERVAL data type. |
| minute | Returns the minute portion of the specified date as an integer. |
| microsecond | Returns the microsecond portion of the specified date as an integer. |
| month | Returns the month portion of the specified date as an integer. |
| overlaps | Evaluates two time periods and returns true when they overlap, false otherwise. |
| quarter | Returns calendar quarter of the specified date as an integer, where the January-March quarter is 1. |
| round_date | Rounds the specified date or time. |
| second | Returns the seconds portion of the specified date as an integer. |
| timestamp | Converts the input value to a TIMESTAMP data type. |
| week | Returns the week of the year for the specified date as an integer, where the first week begins on the first Sunday on or preceding January 1. |
| year | Returns an integer that represents the year portion of the specified date. |
