Hi Ian,

> or update mytable set datefield = cast (extract(day from datefield) ||
> '.' || extract(month from datefield) || '.' || (extract(year from
> datefield)-100) as date)

thanks, this works for me.

> I'm not sure what would happen to leap years though.

I am in the comfortable position that the day and month part of the
date is correct and only the year part is 100 years in the future, so
that I do not need to care for leap years ;-)

Thanks to all of you!


Christian