Revision: 71361
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at February 22, 2017 09:27 by bbrumm
Initial Code
--Example 1 SELECT NUMTODSINTERVAL(14, 'DAY') FROM dual; --Example 2 SELECT NUMTODSINTERVAL(6, 'HOUR') FROM dual; --Example 3 SELECT NUMTODSINTERVAL(32, 'HOUR') FROM dual; --Example 4 SELECT NUMTODSINTERVAL(25, 'MINUTE') FROM dual; --Example 5 SELECT NUMTODSINTERVAL(412, 'MINUTE') FROM dual; --Example 6 SELECT NUMTODSINTERVAL(51, 'SECOND') FROM dual; --Example 7 SELECT NUMTODSINTERVAL(8941564, 'SECOND') FROM dual; --Example 8 SELECT NUMTODSINTERVAL(16.265497, 'SECOND') FROM dual; --Example 9 SELECT NUMTODSINTERVAL(-18, 'HOUR') FROM dual; --Example 10 SELECT NUMTODSINTERVAL(8941564.59401,'SECOND') AS original_value, TO_CHAR ( LPAD(EXTRACT(DAY FROM elapsed_interval),3,'0')||' '|| LPAD(EXTRACT(HOUR FROM elapsed_interval),2,'0')||':'|| LPAD(EXTRACT(MINUTE FROM elapsed_interval),2,'0')||':'|| LPAD(EXTRACT(SECOND FROM elapsed_interval),8,'0') ) AS formatted_seconds FROM ( SELECT numtodsinterval(8941564.59401,'SECOND') AS elapsed_interval FROM dual );
Initial URL
http://www.databasestar.com/oracle-numtodsinterval/
Initial Description
A few examples of the NUMTODSINTERVAL function.
Initial Title
Oracle NUMTODSINTERVAL Function
Initial Tags
sql, Oracle
Initial Language
SQL