mysql - 如何从Sql表中获取两个日期之间的记录

Question

如何从表中获取记录？但仅限 added_on >= '2014/03/01' 的记录和added_on <= '2014/03/31'

目前我的sql表字段值为added_on = 2014/03/29 05:23:43

请尽快帮我解决

Answer 1

简单的SQL查询

select * from table_name where (added_on between '2014-03-01' and '2014-03-31' );

您可能还想指定hh:mm:ss

select * from table_name where (added_on between '2014-03-01 00:00:00' and '2014-03-31 00:00:00' );

两者都应该有效。 :)