Re: Dates

No, only when you do this :

  1 select round(sysdate - to_date('13-APR-00','dd-mon-rr')) days   2* from dual
SQL> /      DAYS

        1

you will get the number of days between two dates.

Sonia Gillespie heeft geschreven in bericht <955698228.28799.0.nnrp-10.9e9859ae_at_news.demon.co.uk>...
>There is a months_between method to calculate the months between a certain
>date. Is there a way of calculating the days between two dates?
>
>--
>Sonia Gillespie
>E-mail: sonia_gillespie_at_lagan.com
>
>
Received on Fri Apr 14 2000 - 00:00:00 CDT