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... --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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. On Oct 20, 3:17 pm, "sullivan.t" <sulliva...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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...--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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 -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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. :P On Oct 21, 9:00 am, August Lilleaas <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> 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 > -- > Posted viahttp://www.ruby-forum.com/.--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---