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: how to get the next valid date?

Re: how to get the next valid date?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 31 Aug 2001 18:05:41 -0700
Message-ID: <9mpc9501rgj@drn.newsguy.com>


In article <629275ba.0108311103.393c0bf4_at_posting.google.com>, gspk_at_yahoo.com says...
>
>Hi,
>
>I have the following issue.
>
>I have to get the 'mm/yyyy' part of date from one column and 'dd' part
>from another column and cobine the both to for the result. When I do
>this, the result could be an invalid date. In such case, I need to get
>the next valid date.
>
>Ex.
>Col1 : 02/10/2000 -- mm/yyyy --> 02/2000 -- a
>Col2 : 10/31/2000 -- dd --> 31 -- b
>
>Res : a oper b --> 02/31/2000
>
>I want it to be either the previous or next valid date. In my case,
>result has to be either '02/29/2000' or '03/01/2000'. Anyone will do.
>
>Is this possible to do in SQL qry? If so, how?
>
>Thanks,

in the future, use one thing or the other...

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1309653202633

...

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 
Received on Fri Aug 31 2001 - 20:05:41 CDT

Original text of this message

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