SQL 日期大于给定日期查询的 Rails
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/7549851/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
提示：将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间：2020-09-01 12:14:20 来源:igfitidea点击:
Rails where date is greater than given date query
提问by Mike
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')
回答by Adam Eberlin
Rails 3+ :
轨道 3+ ：
Movie.where('release > ?', DateTime.now)
Pre Rails 3
预导轨 3
Movie.where(['release > ?', DateTime.now])
