Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Days Between 2 Dates
SQL> select to_date('26FEB2000','DDMONYYYY') - sysdate from dual;
TO_DATE('26FEB2000','DDMONYYYY')-SYSDATE
5.41833333333333333
hth
~Parvinder
Spotly wrote:
> I really have tried hard to figure this out. How do I get the number of days
> between sysdate and '26-FEB-2000'
> Thanks for any help. Tim H.
Received on Sun Feb 20 2000 - 02:27:54 CST