TO_YMINTERVAL(x): Converts the string x to an INTERVAL YEAR TO MONTH : TO_YMINTERVAL « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. TO_YMINTERVAL

TO_YMINTERVAL(x): Converts the string x to an INTERVAL YEAR TO MONTH


SQL>
SQL> --TO_YMINTERVAL(x): Converts the string x to an INTERVAL YEAR TO MONTH.
SQL>
SQL> select to_yminterval('03-11')from dual;

TO_YMINTERVAL('03-11')
---------------------------------------------------------------------------
+000000003-11

SQL>








Related examples in the same category

1.Date + to_yminterval('01-05')
2.to_yminterval('00-01')
3.to_yminterval('01-05')
4.Use to_yminterval in PL/SQL