mysql - SQL Between 查询无法正常工作

Question

SELECT * FROM `incomes` WHERE incomeDate BETWEEN '28-12-2016' and '31-01-2017'

这个查询不起作用但是当我在下面查询时它显示结果

SELECT * FROM `incomes` WHERE incomeDate BETWEEN '28-12-2016' and '31-12-2016'

Answer 1

请更改日期格式，MYSQL比较支持'YYYY-MM-DD'日期格式。请使用以下查询。

SELECT * FROM incomes WHERE incomeDate BETWEEN '2016-12-28' and '2017-01-31'.

希望对您有所帮助。