Posted By

bbrumm on 02/22/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 02/22/17 09:28am

Statistics

Viewed 650 times

Favorited by 0 user(s)

Related snippets

Oracle NUMTOYMINTERVAL Function

/ Published in: SQL

A few examples of the NUMTOYMINTERVAL function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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