Tagged: mysql month

MySQL – Get all sundays in a month

To  get all the Sundays or Saturdays or Mondays you can use the following MySQL code Sunday DAYOFWEEK(DATE_ADD(‘2014-10-01’, INTERVAL ROW DAY))=1 Monday DAYOFWEEK(DATE_ADD(‘2014-10-01’, INTERVAL ROW DAY))=2 Tuesday DAYOFWEEK(DATE_ADD(‘2014-10-01’, INTERVAL ROW DAY))=3 Thursday DAYOFWEEK(DATE_ADD(‘2014-10-01’, INTERVAL...