日期大于给定日期查询的 Rails [英] Rails where date is greater than given date query
本文介绍了日期大于给定日期查询的 Rails的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
试图搜索上映日期比今天晚的电影
Trying to search where movies coming out have a release date greater than today's date
Movie.where('release > ?', Date.today)
ActiveRecord::StatementInvalid: Mysql::ParseError: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'release > '2011-09-25')' at line 1: SELECT `movies`.* FROM `movies` WHERE (release > '2011-09-25')
推荐答案
Rails 3+ :
Movie.where('release > ?', DateTime.now)
<小时>
Pre Rails 3
Movie.where(['release > ?', DateTime.now])
这篇关于日期大于给定日期查询的 Rails的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文