Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

NUMTOYMINTERVAL(3 25, MONTH)

SQL> select NUMTOYMINTERVAL(3.25, 'MONTH') from dual; NUMTOYMINTERVAL(3.25,'MONTH') --------------------------------------------------------------------------- +000000000-03 SQL>