Christian Gütter schrieb am 01.03.2005 16:41:

> is there a reliable way to subtract e. g. 100 years from a
> date value?
>
> My problem is that I would like to subtract 100 years from a given set
> of date values and it would be very convenient to do it with a simple
> SQL statement.

At least approximately:

select datefield - (100 * 365.25) from table

:)

(Problem are the leap years)

> Christian

Magnus