Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Adding days in Oracle 8.1.x
That is it. Just add 1 to any date datatype and you get the next day.
FYI.. there are several functions for dates for things like adding months, rounding, truncating, etc...
For more info on Oracle8i, see docs at:
http://download-east.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/function.htm#998166
"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:10:35 CDT