Re: Week_ISO and the last week of 2008

["Charles Wilt" <charles.wilt@xxxxxxxxx>]

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.