Always use DATE(timestamp) when grouping time-based data per day. ( This ensures that groups are correctly calculated on a daily basis!) use DATE_TRUNC('month', timestamp) when grouping by month.