Posts Tagged ‘Mysql’

Home » Tags » Mysql

26Apr
2009

Week of the Month in Mysql

SELECT WEEK(my_date_field,5) -
WEEK(DATE_SUB(my_date_field, INTERVAL DAYOFMONTH(my_date_field)-1 DAY),5)+1