group by datepart(day,created_at)...

What is the best way in rails, to so something similar to this sql:

select count(*),datepart(month,created_at)
+"/"+datepart(day,created_at) from whatever
group by datepart(month,created_at)+"/"+datepart(day,created_at)

Thoughts? I mean, besides doing it via strict sql...

Had a bit of insight with the "month(created_at)" command, however, I
don't seem to be allowed to use that command from within my models.

Thomas Sullivan wrote:

What is the best way in rails, to so something similar to this sql:

select count(*),datepart(month,created_at)
+"/"+datepart(day,created_at) from whatever
group by datepart(month,created_at)+"/"+datepart(day,created_at)

Thoughts? I mean, besides doing it via strict sql...

Perhaps you can do something like this:

http://railscasts.com/episodes/29-group-by-month

Ahh yes, that'll probably do it. (I will try it soon.)

I guess my days using Sybase Transact are a bit different in
application to SQLite3. :stuck_out_tongue: