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.
On 2/3/06, Paul Halliday <paul.halliday@stripped> 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.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1