Re: Week_ISO and the last week of 2008

I get week 1 also. But that is working as designed, from the manual:

"The week starts with Monday. Week 1 is the first week of the year to
contain a Thursday, which is equivalent to the first week containing
January 4. Thus, it is possible to have up to 3 days at the beginning
of the year appear as the last week of the previous year or to have up
to 3 days at the end of a year appear as the first week of the next
year."

Since Thursday was January 1st, the week from Monday 12-29 to Sunday
1-4 was week one.

Charles

On Tue, Jan 6, 2009 at 12:48 PM, Walden H. Leverich
<WaldenL@xxxxxxxxxxxxxxx> wrote:

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



--

Walden H Leverich III

Tech Software

(516) 627-3800 x3051

WaldenL@xxxxxxxxxxxxxxx

http://www.TechSoftInc.com <http://www.techsoftinc.com/>



Quiquid latine dictum sit altum viditur.

(Whatever is said in Latin seems profound.)



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.