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

Home -> Community -> Usenet -> c.d.o.tools -> Re: increasing dates

Re: increasing dates

From: Beach <chbeach_at_loxinfo.co.th>
Date: Sun, 21 Jan 2001 16:00:06 +0700
Message-ID: <3A6AA516.BB9254D7@loxinfo.co.th> 






with Date Function:   ADD_MONTHS



Syntax: ADD_MONTHS(d,n)



example: SELECT TO_CHAR(ADD_MONTHS(MYDATE,2), 'DD-MON-YYYY') FROM table
WHERE field = xxxx.



Beat Christen



ps; it's all in: ORACLE7 Server   SQL Language Reference Manual




Stanislaw Findeisen wrote:



> how to increase a given date by a month ?

>

> thanks.

Received on Sun Jan 21 2001 - 03:00:06 CST












Original text of this message













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