Subject Re: [firebird-support] Subtract Years from a Date Value in SQL
Author Magnus Titho
Martijn Tonies schrieb am 01.03.2005 17:05:
>
> Perhaps it would be better to write an UDF in which
> you decode the date, subtract 100 years and encode
> it again. That way, the leap years are included.

Yeah, but if the date is a 29.02., you would also have to check if the
calculated year is also a leap year (e.g. 29.02.2000 minus 100 years ->
28.02.1900 ?)


Magnus