Re: How to count day?

From: Erika Grondzakova <grondzak_at_fria.utc.skx>
Date: Mon, 08 Jun 1998 13:20:52 +0200
Message-ID: <357BC914.591_at_fria.utc.skx>


J. Yen wrote:
>
> I like to count day automatically and display the day with the format
> 'dd/mm/yyyy'.
> For example, the expired day will be 35 days after the sysdate. The
> sysdate is 07/06/1998 (dd/mm/yyyy), the expired day will be 11/07/1998
> (dd/mm/yyyy). Does anyone know the function to calculate this
> automatically? Thanks a lot!

select sysdate+34 from dual;

                                                Erika Received on Mon Jun 08 1998 - 13:20:52 CEST

Original text of this message