Group by datepart(day,created_at)

Rails
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. [email protected]

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: