SQL查询语句,条件无效(添加条件跟无条件是一个结果),该如何解决
SQL查询语句,条件无效(添加条件跟无条件是一个结果)
(arrivaltime >= '2012-05-18') AND (lefttime >= '2012-05-19') AND (arrivaltime < '2012-05-19'),这个都能查询出对的结果。请问各位这是哪里的问题。
------解决方案--------------------
- SQL code
SELECT * FROM dingdan WHERE (arrivaltime <= '2012-05-18') SELECT * FROM dingdan
(arrivaltime >= '2012-05-18') AND (lefttime >= '2012-05-19') AND (arrivaltime < '2012-05-19'),这个都能查询出对的结果。请问各位这是哪里的问题。
------解决方案--------------------
- SQL code
SELECT * FROM dingdan WHERE convert(datetiem,arrivaltime,120)<= '2012-05-18'
------解决方案--------------------
- SQL code
SELECT * FROM dingdan WHERE convert(varchar(10),arrivaltime,120)<= '2012-05-18'
------解决方案--------------------
- SQL code
SELECT * FROM dingdan WHERE convert(varchar(10),arrivaltime,120)<= '2012-05-18'