AW: Week_ISO and the last week of 2008

Hi,

no it is correct!
According to the ISO guidelines:
The week always begins with the Monday.
In the first week of a year at least 4 days must be from the new year.
That means January, 4th is always in week1 and the first Thursday of a year
is in week1.

This year January, 1st was a Thursday, in this way January 1st is in week1.
That means that the 12/31/2008, 12/30/2008 and 12/29/2008 must also be in
week1

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"


-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Walden H. Leverich
Gesendet: Tuesday, 06. January 2009 18:48
An: Midrange Systems Technical Discussion
Betreff: Week_ISO and the last week of 2008

According to the spec week_iso should have returned 53 for the end of
2008. On V5R4 I'm getting 1. Can someone please try:



select week_iso(date('12/29/08')) from sysibm/sysdummy1



on their machine and let me know what they get.



Thanks,

-Walden