mysql查询某个时间内数据语句

Question

表名acps 字段cpp time 时间类型date

Answer 1

select * from acps where time>='9' and time<='19';

Answer 2

select cpp from acps where date between "2017-01-08" and "2017-02-08"

Answer 3

between and

Answer 4

好久没有玩数据库了。