Oracle查询每天固定时间段的数据

select * from GPS_LOG t where to_char(t.gps_time,'hh24:mm:ss')>='15:30:00'
and to_char(t.gps_time,'hh24:mm:ss')<='17:00:00' order by t.gps_time

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/peterpanzsy/p/4079912.html