What granularity do you need? Number of days? or Number of days, hours, minutes, seconds?
Santosh Varma wrote:
Hello list,I want to find the difference between 2 dates..Any Oracle function for that ???Thanks and Regards,Santosh
-- Daniel W. Fink http://www.optimaldba.com
IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals