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.