On Mar 22, 9:12 am, "nirav" <shiva..._at_gmail.com> wrote:
> Thanks for these...I also got another very effective way of doing this
> update...
>
> select trunc(add_months(birthdate, 12 * 65) - 1, 'MM')
>
> Now the question is how to update the other table based on this
> calculated value...any suggestions?
>
> For a reference on same issue's discussion in another forum:http://www.orafaq.com/forum/?t=rview&goto=226040#msg_226040
That should be just a matter of writing an update statement using the
values from the first table.
For simplicity you could also use: SELECT birthdate + INTERVAL '65'
YEAR
Received on Thu Mar 22 2007 - 12:31:59 CDT
