1,获得某月最后一天
SELECT TO_CHAR(LAST_DAY(TO_DATE("20140125", "yyyymmdd")), "yyyymmdd") LASTDAY
FROM DUALSELECT TO_CHAR(LAST_DAY(TO_DATE("20141,获得某月最后一天
SELECT TO_CHAR(LAST_DAY(TO_DATE("20140125", "yyyymmdd")), "yyyymmdd") LASTDAY
FROM DUALSELECT TO_CHAR(LAST_DAY(TO_DATE("2014