Re: how to get the next valid date?

Thank you all,

I got the response from TOM's site.

Prince..

Thomas Kyte <tkyte_at_us.oracle.com> wrote in message news:<9mpc9501rgj_at_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
>
> ...
Received on Sat Sep 01 2001 - 02:34:23 CDT