Datetime Functions

For a full description of the datetime data types, see "Datetime Data Types".

The datetime functions are:

• ADD_MONTHS

• EXTRACT

• MONTHS_BETWEEN

• NUMTODSINTERVAL

• NUMTOYMINTERVAL

• ROUND (Date)

• SYSDATE and GETDATE

• TIMESTAMPADD

• TIMESTAMPDIFF

• TO_DATE

• TO_TIMESTAMP

• TRUNC (Date)