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:33SQL>
----------
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:33SQL>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货