Re: Effective ways of doing date arithmatic

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 Received on Thu Mar 22 2007 - 08:12:53 CDT