Group by datepart(day,created_at)


#1

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…


#2

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.


#3

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:

On Oct 21, 9:00 am, August L. removed_email_address@domain.invalid


#4

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