Re: Adding 1900 years to a date

In article <slrncj71pb.c0.rene.nyffenegger_at_zhnt60m34.netarchitects.com>, Rene Nyffenegger says...

>
> RENE_at_ora10>
> RENE_at_ora10> select add_months(to_date('21-sep-0076'),1900*12) from dual;
>
> ADD_MONTHS(
> -----------
> 21-sep-1976
>
>

Thanks - my mind couldn't get beyond add_years (and then finding that such a function didn't exist!)

-- 

jeremy