Time subtraction

[Fampofo]

Hello everyone.
I am have a tough time here and need some help.
I am trying to find the diff between 2 times and display result in hrs or min - but I am not getting the result.
Here is eg. of my query

select to_number((finish_time)-(start_time))

if finish_time is 15:30 and start_time is 14:00 I expect the result to be 1.5 or 90
can anyone help? thanks
frank

 

[sem]

Your TO_NUMBER conversion is redundant since the difference is already a number of days. You may get hours by multplying it by 24.

Regards, Dima

http://seminihin.narod.ru

 

[Fampofo]

Hi sem,
I did try your suggestion and it is working beautifully
thanks a lot
frank