sql="select * from mytable where time="&creatime&""改成sql="select * from mytable where time='"&creatime&"'"或者sql="select * from mytable where time=getdate()"
少了引号了吧
