Subject | Re: [firebird-support] Re: Select extract(week from date '30.12.2008') from rdb$database returns 1 !?! |
---|---|
Author | Matthias Hanft |
Post date | 2008-04-29T09:30:29Z |
Helen Borrie wrote:
dependent. For example, in
http://de.wikipedia.org/wiki/Woche#Z.C3.A4hlweise_nach_DIN_1355_.2F_ISO_8601
it is mentioned (for Germany): "Each year has either 52 or 53 weeks".
Further down that website, for the USA it is mentioned:
"Each year has 53 weeks." (!)
Conclusion: Never rely on any week calucation within internationally
used software :-)
-Matt
>Not always :-) I think, "counting weeks" is heavily country-
> A year has only 52 weeks. :-)
dependent. For example, in
http://de.wikipedia.org/wiki/Woche#Z.C3.A4hlweise_nach_DIN_1355_.2F_ISO_8601
it is mentioned (for Germany): "Each year has either 52 or 53 weeks".
Further down that website, for the USA it is mentioned:
"Each year has 53 weeks." (!)
Conclusion: Never rely on any week calucation within internationally
used software :-)
-Matt