If I would like to get the date of the last day of the month, how to do it?
Oracle had build-in function, LAST_DAY, to fulfill this requirement.
Here is the example:
SELECT to_char(sysdate, 'YYYYMMDD') today, to_char(LAST_DAY(sysdate), 'YYYYMMDD') last_day_of_month FROM dual
Query result :