This section provides you with the most commonly used Oracle date and time functions to help you handle date and time data easily and more effectively.
SYSDATE CURRENT_DATE CURRENT_TIMESTAMP SYSTIMESTAMP ADD_MONTHS MONTHS_BETWEEN NEXT_DAY LAST_DAY ROUND TRUNC