Re: Adding 1900 years to a date

In article <MPG.1b9d84434264ec58989ccf_at_news.individual.net>, Jeremy says...
> Have a load of dates in an 8i (8.1.7.2) database inadvertently loaded as
> e.g.
>
> 21-sep-0076
>
> i..e with the wrong century. What is quickest way of adding the 1900
> years to each of these?
>

Sorry forgot to add that I had thought of e.g.

date_of_birth := date_of_birth + 1900*365

but of course this wouldn't cater for leap years.

Mind has gone blank - welcome a prod!

-- 

jeremy