advanced code snippet search

Posted By

olive on 02/01/07


Tagged

date


Versions (?)

Group by date

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. SELECT date_format(date_submitted,'%Y%m%d'),count(*) FROM mantis_bug_table WHERE project_id =6 AND date_submitted > '2005-02-01' GROUP BY date_format(date_submitted,'%Y%m%d')

Report this snippet  

You need to login to post a comment.