Oracle Date/Time Function - Oracle Date Time Function Example

Oracle/PLSQL ADD_MONTHS Add months to a date

Oracle/PLSQL CURRENT_DATE Get current date

Oracle/PLSQL CURRENT_TIMESTAMP Get current timestamp

Oracle/PLSQL DBTIMEZONE Get database timezone

Oracle/PLSQL EXTRACT Extract date from a date

Oracle/PLSQL FROM_TZ Merge timezone

Oracle/PLSQL LAST_DAY Returns the last day of the month based on a date value

Oracle/PLSQL LOCALTIMESTAMP Get the local timestamp

Oracle/PLSQL MONTHS_BETWEEN Get month count between two dates

Oracle/PLSQL NEW_TIME Create new time

Oracle/PLSQL NEXT_DAY Get the next day from a date

Oracle/PLSQL NUMTODSINTERVAL Converts number to INTERVAL DAY TO SECOND

Oracle/PLSQL NUMTOYMINTERVAL Converts the number x to an INTERVAL YEAR TO MONTH

Oracle/PLSQL ROUND date Round date value

Oracle/PLSQL SESSIONTIMEZONE Returns the current session's time zone as a time zone offset (in the following format: '[+|-]TZH:TZM') or a time zone region name.

Oracle/PLSQL SYSDATE Returns the current system date and time.

Oracle/PLSQL SYSTIMESTAMP Returns the current system date and time including fractional seconds and time zone.

Oracle/PLSQL SYS_EXTRACT_UTC

Oracle/PLSQL TO_DATE Converts a string to a date

Oracle/PLSQL TO_DSINTERVAL Extracts the UTC from a datetime value

Oracle/PLSQL TO_TIMESTAMP Converts string to timestamp

Oracle/PLSQL TO_TIMESTAMP_TZ Converts a string to a timestamp with time zone.

Oracle/PLSQL TO_YMINTERVAL Converts a string to an INTERVAL YEAR TO MONTH type.

Oracle/PLSQL TRUNC date Truncate a date value

Oracle/PLSQL TZ_OFFSET Returns the time zone offset of a value.