Oracle-L: Re: Date difference function

From: Daniel W. Fink <optimaldba_at_yahoo.com>
Date: Mon, 10 Mar 2003 07:19:09 -0800
Message-ID: <F001.00564792.20030310071909@fatcity.com>

Santosh,

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




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel W. Fink
  INET: optimaldba_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Mon Mar 10 2003 - 09:19:09 CST