MVSFORUMS.com

[showkath]

Hi all,

Can anyone help me to solve the following:

I want to find out the week number for the given date as per
MS outlook Calendar calculation in DB2.

For example,

1) if date is 01-jan-2005, then week number is 52
since that week spreads across the years 2004 and 2005.
i.e the date falls on other days other than sunday then
1st jan corresponds to last week of the previous year

2) if date is 01-jan-2006, the week number is 01. i.e the date falls of
sunday means than that week corrsponds to current year

Thanks in advance.
_________________
Regards,
Showkath
-----------------------------------------------------
Our opinions do not really blossom into fruition until we have expressed them to someone else - Mark Twain

[kolusu]

Showkath,

Check the scalar function week which will give you the desired results.The WEEK function returns an integer in the range of 1 to 54 that represents the week of the year. The week starts with Sunday.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/3.2.93?SHELF=&DT=20010718164132&CASE=

Also check this link for WEEK_ISO function which returns an integer in the range of 1 to 53 that represents the week of the year. The week starts with Monday

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/3.2.94?SHELF=&DT=20010718164132&CASE=

Hope this helps...

Cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[showkath]

Dear Kolusu,

Thanks in bunch.

Regards,
Showkath
_________________
Regards,
Showkath
-----------------------------------------------------
Our opinions do not really blossom into fruition until we have expressed them to someone else - Mark Twain