oralce减一分钟

and to_char(z.DINGDANZFSJ, 'yyyy-mm-dd HH24:MI:SS') >=
to_char(sysdate - 2 / 24 / 60, 'yyyy-mm-dd HH24:MI:SS')

原文地址:https://www.cnblogs.com/lwaixd/p/10402652.html