title: Rails 4: GROUP BY date with time zone
body: <p>I am trying to get the number of LaserSheets cut per day to use in a chart. </p>
  
  <p><strong>pages_controller.rb:</strong></p>
  
  <pre><code>start_date = 7.days.ago
  recent_cut_stats = LaserSheet.where('cut_at IS NOT NULL')
                               .where('cut_at &gt; ?', start_date.beginning_of_day)
                               .group("DATE(cut_at)")
                               .count
  </code></pre>
  
  <p>I am running into problems because the rest of my site uses the time zone set in <code>application.rb</code>, but the above query returns results grouped by date in UTC time. After 5:00pm PDT (UTC -0700) I start seeing results for tomorrow. Is there a way to convert <code>group("Date(cut_at)"</code> to the application's time zone?</p>