1.当时间字段是字符类型时,如cssendtime,做法:加167小时
select to_char(to_date(cssendtime,'yyyy-mm-dd hh24:mi:ss')+1/24,'yyyy-mm-dd hh24:mi:ss') from cssf_flow_order order by time_stamp desc;
2当时间字段是Date类型时,如sysdate,做法:加1小时select to_char(sysdate + 1/24,'yyyy-mm-dd hh24:mi:ss') from dual
加一分钟
select to_char(sysdate + 1/(24*60),'yyyy-mm-dd hh24:mi:ss') from dual