Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

To_yminterval(01-05)

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