Subject | Subtract Years from a Date Value in SQL |
---|---|
Author | Christian Gütter |
Post date | 2005-03-01T15:41:31Z |
Hi,
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.
Thanks in advance for your answers,
Christian
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.
Thanks in advance for your answers,
Christian