Re: [PL/SQL} ADD DAY function exist ?

From: Ken Gaul (06) <ken_at_gaul-edin.freeserve.co.uk>
Date: Fri, 07 Jan 2000 16:43:57 +0000
Message-ID: <387617CD.C8A5503B@gaul-edin.freeserve.co.uk>

Just do exactly as you say. Adding a number to a date by default returns the date plus that number of days. Adding to dates together is not really valid if you think about it.

Ken.

"Eric D

> Hi everybody
>
> I have a PL/SQL question, I hope I am in the right newsgroup.
> Anyway, I would like to add days to a date.
>
> L_DATE_IN Date
> L_DAY NUMBER
> L_DATE_OUT Date
>
> My procedure should give me at the end
> L_DATE_OUT := L_DATE_IN + L_DAY
>
> But how do you convert a number to a date ?
> The TO_DATE is a for a full date, I guess
>
> Do you know guys a ADD_DAY function equivalent to ADD_MONTH
>
> Is anybody had this question before ?
>
> Thanks in advance
> --
> Pierre Oub
>
> Remove ".Remove_It" to answer me
Received on Fri Jan 07 2000 - 10:43:57 CST