RSS - Latest posts Posts Tagged ‘week’

Home » Tags » week
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

(more…)

Categories:

4
Posted by Joanna Chlasta at 03:37pm