LAST_DAY 指定日期当月最后一天
格式:LAST_DAY(指定日期)
例:求当月最后一天
itkaifang@SCOTT> SELECT LAST_DAY(SYSDATE) AS day FROM dual; DAY ---------- 2017-03-31 itkaifang@SCOTT>
例:求下个月最后一天
itkaifang@SCOTT> SELECT LAST_DAY(ADD_MONTHS(SYSDATE,1)) AS day FROM dual; DAY ---------- 2017-04-30 itkaifang@SCOTT>