In MySQL, how to return the week of the month?
mysql
Solution
FLOOR((DayOfMonth(dateCol)-1)/7)+1
I'd like to make it clear that this is probably not a good way to divide your data - (see the comments), but that this will get you as close as you can get.
Problem
The year is divided into 12 months. We can break down a month in four weeks. In MySQL, how to return the week of the month? (Example: first week: 2 entries, second week: 5 entries, third week: 3 entries; fourth week: 8 entries) Using Week and WeekOfYear not get the desired result because the functions return the week number YEAR, not month.