Difference between dates

[nread]

Hi

Could someone tell me if there is a function within Oracle that is similar to SQL Servers DATEDIFF...?

I need to establish the difference in seconds between two dates in the following format :

2004:05:10:16:04:33.12

Thanks people....

 

[sem]

You may explicitly subtract dates, the result is number of days:

in_seconds = (end_date-start_date)*24*60*60

Regards, Dima

http://seminihin.narod.ru