Oracle second change time

 
SQL:> select numtodsinterval (365, 'second') from dual;
Result: + 000000000 00:06:05. 000000000;
 
SQL:> select SUBSTR (numtodsinterval (365, 'second'),) from dual;
Result: 00: 06: 05;
 
SQL:> select to_char (to_date ('201312', 'ssss'), 'hh24: mi: ss') from dual;
Result: 00: 16: 40;
 
SQL:> select trunc (30682/3600) | 'hour '| to_char (to_date (mod (30682,3600), 'ssss'), 'fmmi "Minute" ss "second "') from dual;
Result: 8 hours, 31 minutes, 22 seconds;
// Note: The above conversions can only be within 24 hours.
 
SQL:> select trunc (3601*24/3600/24) | 'day' | to_char (to_date (mod (3601*24, * 24), 'ssss '), 'fmhh24 "Hour" mi "Minute" ss "second" ') from dual;
Result: 0 minutes 24 seconds, 1 day, 0 hours;



Author sangei