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!

Problem with subtraction - hour - hour

2877737Mar 14 2018 — edited Mar 16 2018

Hi,

in my table I have two columns including hour of start tasks (start_zad) and the second, hour when the tasks where ended (stop_zad).

I try to get information how long taks last. The hour is in format 24HH:MI (eg 23:44) and type of columns is varchar2.

My query is as below and I get wrong result

Thanks for all help

Paul
This post has been answered by Anton Scheffer on Mar 14 2018
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 13 2018
Added on Mar 14 2018
#date, #sql, #time
28 comments
830 views