Date Functions

·       SYSDATE

·       CURRENT_DATE

·       CURRENT_TIMESTAMP

·       SYSTIMESTAMP

·       LOCALTIMESTAMP

·       DBTIMEZONE

·       SESSIONTIMEZONE

·       ADD_MONTHS

·       MONTHS_BETWEEN

·       NEXT_DAY

·       LAST_DAY

·       EXTRACT

·       ROUND

·       TRUNC

·       NEW_TIME

·       COALESCE