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. |