Database software is not a calendar. The data you put in is the data you get out. If the day is never put in, you'll never get it out.
You need to have some data source that has all the days in it, like an external table, if you want to be able to retrieve that data. Otherwise, you could do it in a UDF or something, perhaps. -Sheeri On 2/3/06, Paul Halliday <[EMAIL PROTECTED]> wrote: > I have the following query: > > select count(*) as cnt, date(timestamp) as day from table where > date_sub(curdate(),interval 14 day) <= timestamp group by day; > > If there are no data for a particular day, it is not included. Is > there a way to include all days even if the result is 0? I saw an > example that included another table with all dates and an inner join > but that seems a little clunky. > > Thanks. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
