request_date 为数据库时间字段
select * from tw_sensors_history where request_date>='2014-01-05' and request_date<='2014-11-15'
and DATE_FORMAT(request_date, '%T' )>='08:00:00' and DATE_FORMAT(request_date, '%T' )<='23:00:00'
request_date 为数据库时间字段
select * from tw_sensors_history where request_date>='2014-01-05' and request_date<='2014-11-15'
and DATE_FORMAT(request_date, '%T' )>='08:00:00' and DATE_FORMAT(request_date, '%T' )<='23:00:00'