日期函数:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html
http://hi.baidu.com/yase_guoguo/blog/item/171c2d4feea83c01b2de0527.html
SQL 时间比较
select * from useroperation where '2009-10-26 00:00:00' < date; //date的类型是datetime
select * from useroperation where DATE_FORMAT('2009-10-26 00:00:00', '%Y-%m-%d %H:%i:%s') < date;
select * from useroperation where TO_DAYS(NOW()) - TO_DAYS(date) =0;