Hi!
Is there a simple way to generate sequences of dates like the following?"2008-07-03 00:00:00""2008-07-04
00:00:00""2008-07-0500:00:00""2008-07-06 00:00:00"
I'd like to join a table to aggregate the number of items for each day
(each item has a timestamp).
For some days however there are no items, resulting in no row instead of
a row with zero items.
I'd like to fill these empty rows.
I hope I could make my problem clear?!
Best regards
Patrick