How to get month name from week number and year I have a week number and a year (e.g. 34 and 2015). I want to get the name of the month to which the specified week belongs. 

How can I do that?
Please try this:

SELECT MONTHNAME(STR_TO_DATE('201534  Monday','%X%V %W')) month_name


Instead of hardcoding the values, you can pass dynamic value also.