Hi Folks,
I would like to use a sql script to add a time and a duration
(in minutes ) to produce a finish time :-
select start_time,duration,start_time + duration
from table
where condition etc.
It works ok for 11.00 + .50 = 11.50, but examples such as 11.00 + 60 or
11.00 + 65 = 11.65 are not so good.
I was hoping some type of to_date formatting might save programming
but I was't able to hit on the right combination.
I would be greatful for any suggestions from people who might
have run into this problem.
Thanks,
Mike.