Oracle Sql如何将自定义的日期型进行加减然后转成字符串呢

例如2016/10/17 10:17:22 加5分钟,然后转成字符串呢?

select to_char(sysdate+5/1440,'yyyy-mm-dd hh24:mi:ss') as timechar from dual
http://www.orafaq.com/faq/how_does_one_add_a_day_hour_minute_second_to_a_date_value

当前时间减去7分钟的时间
select sysdate,sysdate - interval '7' MINUTE from dual;
http://blog.csdn.net/cherayliu/article/details/8085843/
http://www.2cto.com/database/201604/501997.html

http://www.cnblogs.com/xiao-yu/archive/2011/05/24/2055967.html