Get a list of Date in Zoho Analytics Database Query

Get a list of Date in Zoho Analytics Database Query

Hi, is there an option for me to populate a date in the query?
For example,
 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
is what I am looking for the column populate.
I am looking forward to have this. I will also LEFT JOIN the other table 'Date' into this populated date.