oracle 数字取最大值 最小值 要加to_number(TEMPERTURE)
select min(to_number(TEMPERTURE)) from COOL_TBL_***_***where RECORD_TIME between to_date('2015-9-29 10:30:0','yyyy-mm-dd hh24:mi:ss') and to_date('2015-9-29 11:00:0','yyyy-mm-dd hh24:mi:ss') AND ***=1
select min(to_number(TEMPERTURE)) from COOL_TBL_***_***where RECORD_TIME between to_date('2015-9-29 10:30:0','yyyy-mm-dd hh24:mi:ss') and to_date('2015-9-29 11:00:0','yyyy-mm-dd hh24:mi:ss') AND ***=1