|
|
|
Re: URGENT!calculation of difference of time. [message #365877 is a reply to message #365834] |
Wed, 01 March 2000 00:16   |
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.
|
|
|
|