Oracle TO_YMINTERVAL Function - SQL Snipplr Social Repository

Revision: 71366

at February 23, 2017 05:38 by bbrumm

Initial Code

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

Initial URL

http://www.databasestar.com/oracle-to_yminterval/

Initial Description

A few examples of the TO_YMINTERVAL function.

Initial Title

Oracle TO_YMINTERVAL Function

Initial Tags

sql, Oracle

Initial Language

SQL

Choose a language for easy browsing: