我是这么写的 SELECT * FROM tbContent WHERE (AddDttm > '2005-5-20') AND (AddDttm < '2005 - 5 - 23 ') 查询出来的空的! 日期中间不能有空格的SELECT * FROM tbContent WHERE (AddDttm > '2005-5-20') AND (AddDttm < '2005-5-23 ') 你可以用between and SELECT * FROM tbContent WHERE AddDttm between '2005-5-20' AND '2005-5-23 '
FROM tbContent
WHERE (AddDttm > '2005-5-20') AND (AddDttm < '2005 - 5 - 23 ') 查询出来的空的!
日期中间不能有空格的SELECT *
FROM tbContent
WHERE (AddDttm > '2005-5-20') AND (AddDttm < '2005-5-23 ')
你可以用between and SELECT *
FROM tbContent
WHERE AddDttm between '2005-5-20' AND '2005-5-23 '