/ 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;
URL: http://www.databasestar.com/oracle-to_yminterval/