Handy bit of SQL for generating a calendar table in MySQL:
https://gist.github.com/bryhal/4129042
The table is really helpful for when you need to do some analysis on a date series and you have days where nothing happened, but you want those days included.