查询某时间范围内的数据SQL语句

MySQL数据库查询时间段的两种方法

1.BETWEEN

SELECT id FROM m_question WHERE cratedate BETWEEN
TO_DAYS(‘2019-05-31 00:00:00’) and TO_DAYS(‘2019-06-01 00:00:00’) ORDER BY id DESC

2. > < 符号查询

SELECT id FROM m_question WHERE cratedate BETWEEN
‘2019-05-31 00:00:00’ and ‘2019-06-01 14:59:59’ ORDER BY id DESC
或者
SELECT id FROM m_question WHERE cratedate >
‘2019-05-31 00:00:00’ and cratedate < ‘2019-06-01 14:59:59’ ORDER BY id DESC

注意：

between and 包含时间界限，这就相当于>= <=，而> <不包含。