Advertisement
Guest User

Untitled

a guest
Apr 19th, 2015
191
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1. Item.where("created_at > :date OR updated_at > :date", date: "2011-05-29")
  2. > SELECT "items".* FROM "items" WHERE (created_at > '2011-05-29' OR updated_at > '2011-05-29')
  3.  
  4. attributes:
  5. created_at: 2011-05-29 16:07:10.664227
  6. updated_at: 2011-05-29 16:07:10.664229
  7.  
  8. Item.where("created_at > :date OR updated_at > :date", date: "2011-05-29 16:07:10")
  9.  
  10. mysql> SELECT '2011-05-30 12:00:00' > '2011-05-30';
  11. +--------------------------------------+
  12. | '2011-05-30 12:00:00' > '2011-05-30' |
  13. +--------------------------------------+
  14. | 1 |
  15. +--------------------------------------+
  16.  
  17. some_date = Time.now
  18. Item.where("created_at >= :date OR updated_at >= :date", date: some_date.tomorrow.beginning_of_day)
  19.  
  20. Post.after(date)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement