如何使用MySQL在两个日期之间查询?以下查询:SELECT * FROM `objects` WHERE (date_field BETWEEN '2010-09-29 10:15:55' AND '2010-01-30 14:15:55')什么都不回。不过,我应该有足够的数据来执行查询。我做错什么了?
3 回答

慕勒3428872
TA贡献1848条经验 获得超6个赞
SELECT *FROM `objects`WHERE (date_field BETWEEN '2010-01-30 14:15:55' AND '2010-09-29 10:15:55')

阿波罗的战车
TA贡献1862条经验 获得超6个赞
select * from table between `lowerdate` and `upperdate`
SELECT * FROM `objects` WHERE (date_field BETWEEN '2010-01-30 14:15:55' AND '2010-09-29 10:15:55')

一只甜甜圈
TA贡献1836条经验 获得超5个赞
date_field
datetime
SELECT * FROM `objects` WHERE (date_field BETWEEN '2010-01-30 14:15:55' AND '2010-09-29 10:15:55')
添加回答
举报
0/150
提交
取消