Posted By

bbrumm on 02/23/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 02/23/17 05:38am

Statistics

Viewed 843 times

Favorited by 0 user(s)

Related snippets

Oracle TO_YMINTERVAL Function

/ Published in: SQL

A few examples of the TO_YMINTERVAL function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

--TO_DSINTERVAL
 
--Example 1
SELECT TO_YMINTERVAL('02-05') AS INTERVAL_TEST
FROM dual;
 
 
--Example 2
SELECT TO_YMINTERVAL('15-06') AS INTERVAL_TEST
FROM dual;
 
 
--Example 3
SELECT SYSDATE, SYSDATE + TO_YMINTERVAL('4-01') AS INTERVAL_TEST
FROM dual;
 
--Example 4
SELECT TO_YMINTERVAL('P1Y2M') AS INTERVAL_TEST
FROM dual;