> 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
Thanks but the requirements are slightly different...plz refer the
first post where I mentioned it...like go back a month if...and
truncate to first if..etc. your solution does not do that conditional
thing right...but is use of interval..basically superior to
trunc(add_months(birthdate, 12 * 65) - 1, 'MM') approach?
again my thanks for sharing your views
Nirav
Received on Thu Mar 22 2007 - 13:56:48 CDT
