Re: Adding days in Oracle 8.1.x

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Sat, 25 Oct 2003 21:06:44 GMT
Message-ID: <EBBmb.26388$Tr4.54808@attbi_s03>

If the column is a date then just +1 to add 1 day. eg select myDate+1 from mytab ...
Jim
"Tom Miskiewicz" <miskiewicz2_at_yahoo.com> wrote in message news:bneind$2is$1_at_news.gatel.net...
> Hi!
>
> The following statement seems to work:
>
> select to_date('31.10.2003','DD MM YYYY')+1 from dual;
>
> In my environment I will replace the 31.10.2003 with a variable. Is this
way
> of doing it ok, or are there alternatives?
>
>
> Thanks
> Tom
>
>
Received on Sat Oct 25 2003 - 16:06:44 CDT