2012年的面试题，可惜没写出来啊
SQL> select sysdate from dual;SYSDATE-------------------2016-11-09 09:42:44SQL> select trunc(sysdate) from dual;TRUNC(SYSDATE)-------------------2016-11-09 00:00:00SQL> select add_months(sysdate,-1) from dual;ADD_MONTHS(SYSDATE,-------------------2016-10-09 09:43:57SQL> select last_day(add_months(sysdate,-1)) from dual;LAST_DAY(ADD_MONTHS-------------------2016-10-31 09:44:22SQL> select trunc(last_day(add_months(sysdate,-1))) from dual;TRUNC(LAST_DAY(ADD_-------------------2016-10-31 00:00:00SQL> select trunc(last_day(add_months(sysdate,-1)))-1/86400 from dual;TRUNC(LAST_DAY(ADD_-------------------2016-10-30 23:59:59SQL> select sysdate,trunc(last_day(add_months(sysdate,-1)))-1/86400 from dual;SYSDATE TRUNC(LAST_DAY(ADD_------------------- -------------------2016-11-09 09:46:20 2016-10-30 23:59:59
转载于:https://www.cnblogs.com/iyoume2008/p/6045782.html
