In Oracle Database, the NUMTOYMINTERVAL() function converts a number to an INTERVAL YEAR TO MONTH literal.
Category: Oracle
NUMTODSINTERVAL() Function in Oracle
In Oracle Database, the NUMTODSINTERVAL() function converts a number to an INTERVAL DAY TO SECOND literal.
List of Datetime Format Elements in Oracle
Below is a full list of the datetime format elements in Oracle Database.
Continue readingNEXT_DAY() Function in Oracle
In Oracle Database, the NEXT_DAY() function returns the date of the first instance of the specified weekday that is later than the specified date.
TO_CHAR(datetime) Function in Oracle
In Oracle Database, the TO_CHAR(datetime) function converts a datetime or interval value to a VARCHAR2 value in the format specified by the date format.
NEW_TIME() Function in Oracle
In Oracle Database, the NEW_TIME() function converts the date from a specified time zone to another specified time zone, and returns the result.
MONTHS_BETWEEN() Function in Oracle
In Oracle Database, the MONTHS_BETWEEN() function returns the number of months between two dates.
4 Ways to Change the Time Zone in Oracle
In Oracle Database, time zones can be set in various places. Below are four ways to change the time zone when using Oracle.
Continue readingOracle String Functions (Full List)
Below is a list of built-in string/character functions that are available in Oracle Database.
Continue readingLAST_DAY() Function in Oracle
In Oracle Database, the LAST_DAY() function returns the last day of the month that contains the supplied date.
It accepts one argument, which is the date for which you want to find the last day of the month.
Continue reading