Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |