I have run into that problem multiple times, and I have used this gem to deal with it: https://github.com/ankane/groupdate
It only supports MySQL and PostgreSQL, so a solution that works across different databases would be welcome, in my view. On Saturday, 26 October 2013 12:32:41 UTC+11, Leonardo D. Schlossmacher wrote: > > I'm not sure if this fits in Rails' core but since I spent sometime trying > to solve a problem and couldn't find any solution, I decided to share this > method I've created to extend ActiveRecord::Relation. > > Here's a Gist of it: https://gist.github.com/leods92/7164159 > > The problem is that when we try grouping timestamps by date, SQL returns > unexpected results as it's not aware of time zones. > Rails though is aware of them so I believe it should be used to handle > this issue properly. > By using #group_date one can get any set of records grouped by date from a > timestamp column. > This is very common to generate statistics. > > What do you guys think of it? > Have you ever stumbled on a similar problem? > How have you dealt with it? > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/rubyonrails-core. For more options, visit https://groups.google.com/groups/opt_out.
