Adding days in Oracle 8.1.x

#1

Hallo!

Can someone tell me please how to add days to a given date in Oracle 8?
I'm checked the SQL Reference, but I can find a function like that. Is this
possible?

Regards

Thomas

#2

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

#3

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 (DOT) com> wrote

Quote:

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

#4

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...ion.htm#998166

"Tom Miskiewicz" <miskiewicz2 (AT) yahoo (DOT) com> wrote

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Adding days in Oracle 8.1.x

comp.databases.oracle.server comp.databases.oracle.server

Adding days in Oracle 8.1.x - 10-25-2003 , 02:08 PM

Re: Adding days in Oracle 8.1.x - 10-25-2003 , 02:24 PM

Re: Adding days in Oracle 8.1.x - 10-25-2003 , 04:06 PM

Re: Adding days in Oracle 8.1.x - 10-25-2003 , 04:10 PM