日期大于给定日期查询的Rails

六个六

尝试搜索电影上映日期比今天大的地方
0 \% f9 c  d( U: X Movie.where('release > ?', Date.today)
) ?2 w- c) Y5 y" e1 `* ]& {$ i4 oActiveRecord::StatementInvalid: Mysql:arseError: 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')
7 X0 A9 S' \2 c2 a) D  ]" n; P! v3 T               
0 T: Z: q; P6 l% V- b  q解决方案:
               
% c0 D% `" ?- B9 |1 X/ q

                Rails 3+：
% C3 o( ]' g8 S7 ~5 _Movie.where('release > ?', DateTime.now)

; Z5 R/ O: u- N, L3 i4 u预导轨3
Movie.where(['release > ?', DateTime.now])