What is the way to get the timespan between two dates in Oracle 9i

Question

Hi,

Which is the best way in Oracle 9i to get the difference between two dates including the times ? Something like the Timespan function in C#.

Thanks, Chak

Answer 1

When you subtract two dates you get the difference in days. If you multiply that number by 24 you have the difference in hours. Multiply that number by 60 you have the difference in minutes, etc.

Answer 2

You can express the difference as a numeric number of days, or as an interval data type: http://download.oracle.com/docs/cd/B10501%5F01/server.920/a96540/expressions9a.htm#1033525