The following table lists the available date functions, and a description of their purpose.
| Function | Description |
|---|---|
| LAST_DAY | Returns the date of the last day of month that contains date_timestamp_value. |
| NEXT_DAY | Returns the date of the first weekday (day_value) that is later than the date specified by date_timestamp_value. |
| MONTHS_BETWEEN | Returns the number of months between date_timestamp_value1 and date_timestamp_value2. |
| OADD_MONTHS | Adds a specified date_timestamp_value to a specified num_months and returns the resulting date. |
| ROUND | Returns date_value with the time portion of the day truncated to the unit specified by fmt (nearest day if omitted). |
| TRUNC | Returns date_value with the time portion of the day rounded to the unit specified by fmt (nearest day if omitted). |
See the Teradata Database SQL Functions, Operators, Expressions, and Predicates document, B035-1145, for a detailed overview of these date functions.