LAST_DAY

 =LAST_DAY =

Description:
This function is used to get the last day of a month.

FROM dual

 * LAST_DAY(SYSDATE) ||
 * 31-MAR-09 ||

FROM employees
|| Abel || Ellen || 11-MAY-96 || 31-MAY-96 || || Taylor || Jonathon || 24-MAR-98 || <span style="font-family: 'Courier New', Courier, monospace;">31-MAR-98 || || <span style="font-family: 'Courier New', Courier, monospace;">Grant || <span style="font-family: 'Courier New', Courier, monospace;">Kimberly || <span style="font-family: 'Courier New', Courier, monospace;">24-MAY-99 || <span style="font-family: 'Courier New', Courier, monospace;">31-MAY-99 ||
 * <span style="font-family: 'Courier New', Courier, monospace;">EMPLOYEE_ID || <span style="font-family: 'Courier New', Courier, monospace;">LAST_NAME || <span style="font-family: 'Courier New', Courier, monospace;">FIRST_NAME || <span style="font-family: 'Courier New', Courier, monospace;">HIRE_DATE || <span style="font-family: 'Courier New', Courier, monospace;">LAST_DAY(HIRE_DATE) ||
 * <span style="font-family: 'Courier New', Courier, monospace;">100 || <span style="font-family: 'Courier New', Courier, monospace;">King || <span style="font-family: 'Courier New', Courier, monospace;"> Steven || <span style="font-family: 'Courier New', Courier, monospace;"> 17-JUN-87 || <span style="font-family: 'Courier New', Courier, monospace;"> 30-JUN-87 ||
 * <span style="font-family: 'Courier New', Courier, monospace;">101 || <span style="font-family: 'Courier New', Courier, monospace;">Kochhar || <span style="font-family: 'Courier New', Courier, monospace;">Neena || <span style="font-family: 'Courier New', Courier, monospace;">21-SEP-89 || <span style="font-family: 'Courier New', Courier, monospace;">30-SEP-89 ||
 * <span style="font-family: 'Courier New', Courier, monospace;">102 || <span style="font-family: 'Courier New', Courier, monospace;">De Haan || <span style="font-family: 'Courier New', Courier, monospace;">Lex || <span style="font-family: 'Courier New', Courier, monospace;">13-JAN-93 || <span style="font-family: 'Courier New', Courier, monospace;">31-JAN-93 ||
 * <span style="font-family: 'Courier New', Courier, monospace;">200 || <span style="font-family: 'Courier New', Courier, monospace;">Whalen || <span style="font-family: 'Courier New', Courier, monospace;">Jennifer || <span style="font-family: 'Courier New', Courier, monospace;">17-SEP-87 || <span style="font-family: 'Courier New', Courier, monospace;">30-SEP-87 ||
 * <span style="font-family: 'Courier New', Courier, monospace;">205 || <span style="font-family: 'Courier New', Courier, monospace;">Higgins || <span style="font-family: 'Courier New', Courier, monospace;">Shelley || <span style="font-family: 'Courier New', Courier, monospace;">07-JUN-94 || <span style="font-family: 'Courier New', Courier, monospace;">30-JUN-94 ||
 * <span style="font-family: 'Courier New', Courier, monospace;">206 || <span style="font-family: 'Courier New', Courier, monospace;">Gietz || <span style="font-family: 'Courier New', Courier, monospace;">William || <span style="font-family: 'Courier New', Courier, monospace;">07-JUN-94 || <span style="font-family: 'Courier New', Courier, monospace;">30-JUN-94 ||
 * <span style="font-family: 'Courier New', Courier, monospace;">149 || <span style="font-family: 'Courier New', Courier, monospace;">Zlotkey || <span style="font-family: 'Courier New', Courier, monospace;">Eleni || <span style="font-family: 'Courier New', Courier, monospace;">29-JAN-00 || <span style="font-family: 'Courier New', Courier, monospace;">30-JAN-00 ||
 * <span style="font-family: 'Courier New', Courier, monospace;"><span style="font-family: 'Courier New', Courier, monospace;">174
 * <span style="font-family: 'Courier New', Courier, monospace;"><span style="font-family: 'Courier New', Courier, monospace;">176
 * <span style="font-family: 'Courier New', Courier, monospace;"><span style="font-family: 'Courier New', Courier, monospace;">178

<span style="font-family: 'Courier New', Courier, monospace;">FROM dual
<span style="display: block; color: #000000; font-family: 'Courier New', Courier, monospace; text-align: left;">
 * <span style="font-family: 'Courier New', Courier, monospace;">LAST_DAY('19-MAY-92') ||
 * <span style="font-family: 'Courier New', Courier, monospace;">31-MAY-92 ||