Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Adding days in Oracle 8.1.x

Re: Adding days in Oracle 8.1.x

From: Tom Miskiewicz <miskiewicz2_at_yahoo.com>
Date: Sat, 25 Oct 2003 21:24:57 +0200
Message-ID: <bneind$2is$1@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 - 14:24:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US