Re: finding # of days between two dates?

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