That would be run on your data set not on a table of dates. your_table would be the table you want to select stuff from, not a list of dates. http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html contains a usefull list of MySQL's date functinos.