Is there a mysql function which will return the week of the month given a date ex:
date = 01-10-2003 week = 1
date = 05-10-2003 week = 2
Working with NOW() as the date this works:
SELECT CAST(DAYOFMONTH(NOW())/7+1 AS SIGNED);
The cast is just to get the result as an integer, but there might be an easier way of doing that.
