select min(to_date(aa.createdate, 'yyyy-MM-dd hh24:mi')) 最小时间, max(to_date(aa.createdate, 'yyyy-MM-dd hh24:mi')) 最大时间 from (select * from t_windturbine_minutes t where t.windturbinecode = '10103' and t.indicode = '10290') aa
select min(to_date(aa.createdate, 'yyyy-MM-dd hh24:mi')) 最小时间, max(to_date(aa.createdate, 'yyyy-MM-dd hh24:mi')) 最大时间 from (select * from t_windturbine_minutes t where t.windturbinecode = '10103' and t.indicode = '10290') aa
转载于:https://www.cnblogs.com/wllzbky/p/3425278.html