deadline类型为datetime类型
sqlserver2008:select uid from vipusers where deadline>getdate()
mysql:update vipusers set vipflag=0 where deadline < date_format(curdate(),'%Y-%m-%d %h:%i:%s')
比较mysql日期中Y与y的区别:
select date_format(now(),'%Y-%m-%d %h:%i:%s'); 运行结果:2012-12-28 01:47:29
select date_format(now(),'%y-%m-%d %h:%i:%s'); 运行结果:12-12-28 01:48:40