我正在从mysql数据库中查询日期。当我尝试只选择某个from和to日期之间的日期时,我得不到预期的结果。
我的问题是:
select * from tbl_billing where date BETWEEN '09-02-2017' and '10-02-2017'我的输出:
09-02-2017
10-02-2017
10-01-2017
09-01-2017
09-01-2017我想要的结果是:
09-02-2017
10-02-2017发布于 2017-02-18 19:50:04
您可以使用规范的sql日期格式
select * from tbl_billing where date BETWEEN '2017-02-09' and '2017-02-10'或使用str_to_date正确转换
select * from tbl_billing where date BETWEEN str_to_date('09-02-2017', '%d-%m-%Y')
and str_to_date('10-02-2017', '%d-%m-%Y')但是,如果您的date也是一个varchar,那么您也必须转换此列
select * from tbl_billing where str_to_date(date,'%d-%m-%Y') BETWEEN str_to_date('09-02-2017', '%d-%m-%Y')
and str_to_date('10-02-2017', '%d-%m-%Y')https://stackoverflow.com/questions/42314651
复制相似问题