SELECT *
from t_traffic_accident
where
ACCIDENT_TIME > (sysdate - to_dsinterval('0 1:00:00'))
and ACCIDENT_TIME < sysdate
oracle查询最近一小时的数据
最新推荐文章于 2024-06-21 11:12:18 发布
SELECT *
from t_traffic_accident
where
ACCIDENT_TIME > (sysdate - to_dsinterval('0 1:00:00'))
and ACCIDENT_TIME < sysdate