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

posted @ 2016-12-26 11:07  李清欣  阅读(21694)  评论(0编辑  收藏  举报