check this post :
almost the same thing you want to do (except it is per monthes not per
your query should look like it:
Post.find :all, :group => "DATE_FORMAT(date,'%Y-%m-%d')"
i'm not sure about DATE_FORMAT synthax, it is a mysql function but
psql user you must check it.