如图,mysql查询某年某月某日到某年某月某日的数据sql语句怎么写?
select * from tb where dateCol between '2016-01-01' and '2017-01-01'
select * from tb where dateCol > '2016-11-24' and datacol< '2016-12-29'结尾要加一天