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