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

六个六

尝试搜索电影上映日期比今天大的地方
Movie.where('release > ?', Date.today)
6 k: @7 H& U9 ~ActiveRecord::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')
               
0 `0 B# _/ U- p8 A4 \5 V解决方案:
4 L5 v5 P/ ~2 C               

+ U9 v3 [  \* V. I! Q6 ~3 S) \
                Rails 3+：
% P0 O+ c6 L" Y4 y7 q6 jMovie.where('release > ?', DateTime.now)

  F- [2 I" U* i预导轨3
4 _( U1 w/ R& a" x: c. }Movie.where(['release > ?', DateTime.now])