世界末日

世界末日什么时候呢......

SQL> select sysdate + 12*30*8000 from dual;

SYSDATE+12*30*8000
-------------------
9893-02-25 15:29:16

SQL> select last_day(sysdate + 12*30*8108 + 120) from dual;

LAST_DAY(SYSDATE+12
-------------------
9999-12-31 15:31:19

SQL> select last_day(trunc(sysdate + 1) - 1/(24*60*60) + 12*30*8108 + 120) from dual;

LAST_DAY(TRUNC(SYSD
-------------------
9999-12-31 23:59:59

SQL> select last_day(trunc(sysdate + 1) - 1/(24*60*60) + 12*30*8108 + 120) + 1/(24*60*60) from dual;

select last_day(trunc(sysdate + 1) - 1/(24*60*60) + 12*30*8108 + 120) + 1/(24*60*60) from dual
*
ERROR at line 1:
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/45259/viewspace-134958/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/45259/viewspace-134958/