|
|
|
Re: URGENT!calculation of difference of time. [message #365877 is a reply to message #365834] |
Wed, 01 March 2000 00:16 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Glenn J. Dean
Messages: 1 Registered: March 2000
|
Junior Member |
|
|
This works to a point. The difference is calculated as an ascii difference not a numeric difference. I need to do this same thing but as a numeric difference. Can anyone fix this code to calculate a numeric difference instead of an ascii difference?
to_number(to_char(todate,'HH24.MI'))-to_number(to_char(fromdate,'HH24.MI'))
Thanks for the help.
|
|
|
|