Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

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
28 comments
573 views