Re: How to count day?
From: Thomas Mettling <mettling_at_volpe.dot.gov>
Date: Wed, 10 Jun 1998 12:49:18 -0400
Message-ID: <357EB90D.5FCD052_at_volpe.dot.gov>
Date: Wed, 10 Jun 1998 12:49:18 -0400
Message-ID: <357EB90D.5FCD052_at_volpe.dot.gov>
use to_char(sysdate + 35,'dd/mm/yyyy')
-- Tom Mettling WT Chen & Company, Inc. mettling_at_volpe.dot.gov J. Yen wrote:Received on Wed Jun 10 1998 - 18:49:18 CEST
> 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!