Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

NUMTODSINTERVAL(3 25, HOUR)

SQL> SQL> select NUMTODSINTERVAL(3.25, 'HOUR') from dual; NUMTODSINTERVAL(3.25,'HOUR') --------------------------------------------------------------------------- +000000000 03:15:00.000000000 SQL>