I'm unable to get SQL and Rails to play properly when trying to find Categories that are created each day, the past 7 days.
So basically I want to find each开发者_如何学JAVA Category sorted by the day they were created for the past 7 days.
I found this on stackoverflow, but it isn't finding a Category that I just created:
Category.all(:conditions => ["created_at > ? AND created_at < ?", t.at_beginning_of_day, t.tomorrow.at_beginning_of_day])
Any help?
Turns out it was UTC time difference.
range = "created_at #{(5.days.ago.utc...Time.now.utc).to_s(:db)}"
Category.all(:conditions => range)
That did the trick. Can anyone tell me if there is a better way to do it?
精彩评论