sql 带日期求错解决方法

2013-01-02

sql 带日期求错dim shijian as date VB环境定义的shijian2011-1-1 0:0:1sqlselect * from table1 w

sql 带日期求错
dim shijian as date 'VB环境定义的
shijian="2011-1-1 0:0:1"
sql="select * from table1 where table_date< "&shijian&""
报错是“AM附近有语法错误”
[解决办法]
shijian = "2011-5-1 0:0:1" '更新早期的日期
shijian = convert.todatetime(shijian).tostring("yyyy-MM-dd HH:mm:ss")

sql="select * from table1 where datediff(second,table_date,'"&shijian&"')>=0"