Oracle按时间查询条件

GPS平台、网站建设、软件开发、系统运维，找森大网络科技！
https://cnsendnet.taobao.com
来自森大科技官方博客
http://www.cnsendblog.com/index.php/?p=2179

 

/*根据这个字段可以查另一个报警rapid_deceleration_alarm*/
select GPS_TIME,RECEIVE_TIME,temperature_alarm,FIRST_TEMPERATURE_SENSOR_DATA
from GPS_TRACK_INFO where VEHICLE_ID=81477130 and RECEIVE_TIME> to_date('2015-07-06 00:00:00','YYYY-MM-DD HH24:MI:SS')
and temperature_alarm = 1

SELECT * FROM gps_track_info
WHERE VEHICLE_ID=4224
AND to_char(RECEIVE_TIME,'YYYY-MM-DD')>='2015-06-20' and to_char(RECEIVE_TIME,'YYYY-MM-DD')<='2015-06-30'
order by RECEIVE_TIME desc