日期:2014-05-18 浏览次数:20523 次
SELECT * FROM dingdan WHERE (arrivaltime <= '2012-05-18') SELECT * FROM dingdan
SELECT * FROM dingdan WHERE convert(datetiem,arrivaltime,120)<= '2012-05-18'
------解决方案--------------------
SELECT * FROM dingdan WHERE convert(varchar(10),arrivaltime,120)<= '2012-05-18'
------解决方案--------------------
SELECT * FROM dingdan WHERE convert(varchar(10),arrivaltime,120)<= '2012-05-18'