Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: finding # of days between two dates?

Re: finding # of days between two dates?

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Sat, 09 Nov 2002 00:18:32 GMT
Message-ID: <svYy9.6$rn5.1579056@newssvr14.news.prodigy.com>


Mike Cohen wrote:
> Hi,
>
> How would I find the number of days between two Oracle dates? Is
> there a simple function I can utilize?
>
> Thanks!!
>
> Mike

How about something like:

select to_date('20021108','yyyymmdd') - to_date('20021105','yyyymmdd') from dual;

or maybe this:

select trunc(tabledate1) - trunc(tabledate2) from table; Received on Fri Nov 08 2002 - 18:18:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US