Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

time calculation between two time as timestamp

Ramani_apexMar 25 2015 — edited Mar 26 2015

how can calculate from two time ,START TIME as time stamp in datatype,END TIME as time stamp also.

select END_TIME-START_TIME from PROG_DLY_WORK

Result

+000000000 01:50:00.000000

how can get exactly elapsed time as 01:50:00 ? and these calculated time need to sum(elapsed_time) in another column.

environment in oracle cloud as PaaS

PRODUCTVERSIONSTATUS
NLSRTL11.2.0.3.0Production
Oracle Database 11g Enterprise Edition11.2.0.3.064bit Production
PL/SQL11.2.0.3.0Production
TNS for Linux:11.2.0.3.0Production
This post has been answered by ReemaPuri on Mar 26 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2015
Added on Mar 25 2015
13 comments
2,749 views