Answers for "oracle convert run duration to number"

oracle convert run duration to number

-- Duration between 2 timestamps
SELECT (extract(DAY FROM TIME2 - TIME1) * 24 * 60 * 60) 
           + (extract(HOUR FROM TIME2 - TIME1) * 60 * 60) 
           + (extract(MINUTE FROM TIME2 - TIME1) * 60) 
           + extract(SECOND FROM TIME2 - TIME1)
FROM DUAL;

Posted by: Guest on March-15-2021

Code answers related to "oracle convert run duration to number"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "oracle convert run duration to number"

Code answers related to "oracle convert run duration to number"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "oracle convert run duration to number"

Code answers related to "oracle convert run duration to number"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us