Question

mysql中如何查询两个时间段(timestamp)间的数据

想要查询4月1日至5月13日的数据,那么sql语句应该怎样写？
我最后用“SELECT * FROM order_manager_list WHERE " +"date_format(order_time,'%Y%m%d') BETWEEN '" + date + "' AND '" + date2 + "'"”解决了

Answer 1

select * from table_demo where time>unix_timestamp('2010-04-01'者歼) and time <= unix_timestamp('2010-05-13'掘氏'判嫌散)

Answer 2

select
*
from
table_demo
where
time>告让unix_timestamp('2010-04-01')
and
time
<=
unix_timestamp('碧毁2010-05-13'袜慧局')

Answer 3

select * from table_name where date(timestamp)>慧或='2010-4-1' and date(timestamp)<='2010-5-13'前销伍斗纳;