Advanced Search

Return to Snippet

Revision: 71362
at February 22, 2017 09:28 by bbrumm
Initial Code 
--NUMTOYMINTERVAL


--Example 1
SELECT NUMTOYMINTERVAL(15, 'YEAR') AS YMTEST
FROM dual;


--Example 2
SELECT NUMTOYMINTERVAL(23, 'MONTH') AS YMTEST
FROM dual;


--Example 3
SELECT NUMTOYMINTERVAL(-4, 'YEAR') AS YMTEST
FROM dual;


--Example 4
SELECT NUMTOYMINTERVAL(-18, 'MONTH') AS YMTEST
FROM dual;
Initial URL 
http://www.databasestar.com/oracle-numtoyminterval/
Initial Description 
A few examples of the NUMTOYMINTERVAL function.
Initial Title 
Oracle NUMTOYMINTERVAL Function
Initial Tags 
sql, Oracle
Initial Language 
SQL