Oracle – Select sysdate +/- time from dual

如果想+，-系统时间：

 

Sysdate:

SQL> SELECT TO_CHAR(SYSDATE, 'dd-mm-yy hh24:mi:ss') from dual；

 

Days:

SQL> SELECT TO_CHAR(SYSDATE -1, 'dd-mm-yy hh24:mi:ss') from dual;

Hours:

SQL> SELECT TO_CHAR(SYSDATE-(1/24), 'dd-mm-yy hh24:mi:ss') from dual;

Minutes:

SQL> SELECT TO_CHAR(SYSDATE-1/(24*60), 'dd-mm-yy hh24:mi:ss') from dual;

Seconds:

SQL> SELECT TO_CHAR(SYSDATE-1/(24*60*60), 'dd-mm-yy hh24:mi:ss') from dual;

 

你也可以用+ 取代- 获得 加的结果

SQL> SELECT TO_CHAR(SYSDATE +1, 'dd-mm-yy hh24:mi:ss') from dual;