Oracle查询时间字段并排序

select * from geimstatus_history t
where to_date(t.data_time,'YYYY-mm-dd') = to_date(sysdate,'YYYY-mm-dd')
AND t.car_state='11'
order by t.gei_mes desc, t.data_time desc

原文地址:https://www.cnblogs.com/xinxin1994/p/6221615.html