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博客 ” ，链接：https://blog.itpub.net/45259/viewspace-134958/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- How to get server IP address
- 依据统计信息确定多块读被使用
- I'll be there for you
- About storage parameter INITRANS and MAXTRANS
- Instance allocated memory (SGA+PGA)
- PLS-00231 private function is not in scope in SQL
- Fetch limit and %NOTFOUND attribute
- About Merge statement
- Oracle提供的密码复杂度函数
- Enable/disable listener logging
