LINK
//https://help.zoho.com/portal/en/community/topic/get-a-list-of-date-in-zoho-analytics-database-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


Step1: Create 3 tables as below.
* Year - Add entries for year as a column (Eg 2009,2010,,,,2020) as number column
* Month  Add entries of 12 months (01,02,03....12) as plain text column
* Day -  Add entries of 31 dayss (01,02,03....31) as plain text column  

Step 2: Create a Query Table with the below query.

SELECT date(str_to_date(concat("Year"."Year", '-', "Month"."Month", '-', "Day"."Day"), '%Y-%m-%d')) as "Date"
FROM "Year",
"Month",
"Day"
WHERE (("Year" % 400 = 0
OR ("Year" % 100 != 0
AND "Year" % 4 = 0))
AND date_format(date(str_to_date(concat("Year"."Year", '-', "Month"."Month", '-', "Day"."Day"), '%Y-%m-%d')), '%m%d') not in ( '0230' , '0231' , '0431' , '0631' , '0931' , '1131' ))
OR (("Year" % 4 != 0
OR ("Year" % 100 = 0
AND "Year" % 400 != 0))
AND date_format(date(str_to_date(concat("Year"."Year", '-', "Month"."Month", '-', "Day"."Day"), '%Y-%m-%d')), '%m%d') not in ( '0229' , '0230' , '0231' , '0431' , '0631' , '0931' , '1131' ))