Using standard mysql functions it is possible to method to write a question which will return a listing of days between two dates.

eg given 2009-01-01 and 2009-01-13 it might return a 1 column table using the values:

  • 2009-01-01
  • 2009-01-02
  • 2009-01-03
  • 2009-01-04
  • 2009-01-05
  • 2009-01-06
  • 2009-01-07
  • 2009-01-08
  • 2009-01-09
  • 2009-01-10
  • 2009-01-11
  • 2009-01-12
  • 2009-01-13

Edit: It seems I haven't been obvious. I wish to GENERATE this list. I've values saved within the database (by datetime) but would like them to become aggregated on the left outer join to a listing of dates as above (I'm expecting null in the right side of a number of this join for many days and can handle this).