SYSDATE Last Days Left --------- --------- ---------- 30-MAY-01 31-MAY-01 1 SELECT * FROM ## WHERE todate sysdate-to_date('1982/12/12')<100
SQL> select sysdate from dual;SYSDATE ---------- 20-2月 -03SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') 2 as "today is:" 3 from dual;today is: ------------------- 2003-02-20 14:23:10SQL> select sysdate-1 from dual;SYSDATE-1 ---------- 19-2月 -03SQL> select to_char(sysdate-1,'yyyy-mm-dd hh24:mi:ss') 2 as "the day before yesterday" 3 from dual;the day before yest ------------------- 2003-02-19 14:23:33日期+数字:在某个日期上添加指定数量的日 日期-数字:在某个日期上减去指定数量的日日期+数字/24:在某个日期上添加指定数量的小时
LAST_DAY(SYSDATE) "Last",
LAST_DAY(SYSDATE) - SYSDATE "Days Left"
FROM DUAL;
SYSDATE Last Days Left
--------- --------- ----------
30-MAY-01 31-MAY-01 1
SELECT * FROM ## WHERE todate sysdate-to_date('1982/12/12')<100
----------
20-2月 -03SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')
2 as "today is:"
3 from dual;today is:
-------------------
2003-02-20 14:23:10SQL> select sysdate-1 from dual;SYSDATE-1
----------
19-2月 -03SQL> select to_char(sysdate-1,'yyyy-mm-dd hh24:mi:ss')
2 as "the day before yesterday"
3 from dual;the day before yest
-------------------
2003-02-19 14:23:33日期+数字:在某个日期上添加指定数量的日
日期-数字:在某个日期上减去指定数量的日日期+数字/24:在某个日期上添加指定数量的小时