SELECT * FROM TABLENAME WHERE RQ BETWEEN '2007-7-4' AND '2007-8-10'数据库中RQ列是VARCHAR(10),格式是'YYYY-M-D'用这个查找不出 2007-7-4至2007-7-31的数据是为什么呢?
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/28 23:20:58
![SELECT * FROM TABLENAME WHERE RQ BETWEEN '2007-7-4' AND '2007-8-10'数据库中RQ列是VARCHAR(10),格式是'YYYY-M-D'用这个查找不出 2007-7-4至2007-7-31的数据是为什么呢?](/uploads/image/z/10130545-1-5.jpg?t=SELECT+%2A+FROM+TABLENAME+WHERE+RQ+BETWEEN+%272007-7-4%27+AND+%272007-8-10%27%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%ADRQ%E5%88%97%E6%98%AFVARCHAR%2810%29%2C%E6%A0%BC%E5%BC%8F%E6%98%AF%27YYYY-M-D%27%E7%94%A8%E8%BF%99%E4%B8%AA%E6%9F%A5%E6%89%BE%E4%B8%8D%E5%87%BA+2007-7-4%E8%87%B32007-7-31%E7%9A%84%E6%95%B0%E6%8D%AE%E6%98%AF%E4%B8%BA%E4%BB%80%E4%B9%88%E5%91%A2%3F)
xՓN@_evUCC;f`
a%T"q`
4c1*$&F_ff`+8\ӳ5lߙibtH<6жMK&$&AfH@HIXQrXH$UE}^{g\ޮaƓ*>uCiO