select * from CNG_SCADA_HISTORY_HOUR where to_char(create_time,'yyyy-mm-dd hh24') > (select to_char(to_date(to_char(sysdate,'yyyy-mm-dd hh24'),'yyyy-mm-dd hh24')-1,'yyyy-mm-dd hh24') FROM DUAL) and
to_char(create_time,'yyyy-mm-dd hh24') < (select to_char(sysdate,'yyyy-mm-dd hh24') FROM DUAL)
、
select to_char(to_date(to_char(sysdate,'yyyy-mm-dd hh24'),'yyyy-mm-dd hh24')-1/24,'yyyy-mm-dd hh24') FROM DUAL