Thursday, March 27, 2014

return the end of week date using month and week number

Hi all,


I am trying to find the date for end of the week using given month (201401, 201402...i.e, 2014 is year and 01,02 are months) and week number (01,02,03...) for the year. For example if my month is 201402 and week_number is 06 then it return the week_date as 2014-02-08. Can you please help me in writing a sql statement for this scenario.


Thanks in advance,


Nikhil


No comments:

Post a Comment