Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. NUMTODSINTERVAL(3 25, HOUR)
SQL>
SQL> select NUMTODSINTERVAL(3.25, 'HOUR') from dual;
NUMTODSINTERVAL(3.25,'HOUR')
---------------------------------------------------------------------------
+000000000 03:15:00.000000000
SQL>