Subject | Re: [firebird-support] Subtract Years from a Date Value in SQL |
---|---|
Author | Magnus Titho |
Post date | 2005-03-01T16:20:22Z |
Martijn Tonies schrieb am 01.03.2005 17:05:
calculated year is also a leap year (e.g. 29.02.2000 minus 100 years ->
28.02.1900 ?)
Magnus
>Yeah, but if the date is a 29.02., you would also have to check if the
> 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.
calculated year is also a leap year (e.g. 29.02.2000 minus 100 years ->
28.02.1900 ?)
Magnus