to_yminterval('01-05') : TO_YMINTERVAL « Date Timezone « Oracle PL / SQL






to_yminterval('01-05')


SQL> select to_yminterval('01-05') from dual;

TO_YMINTERVAL('01-05')
---------------------------------------------------------------------------
+000000001-05

SQL>
           
       








Related examples in the same category

1.TO_YMINTERVAL(x): Converts the string x to an INTERVAL YEAR TO MONTH
2.Date + to_yminterval('01-05')
3.to_yminterval('00-01')
4.Use to_yminterval in PL/SQL