Oracle / PLSQL: LAST_DAY Function
This Oracle tutorial explains how to use the Oracle/PLSQL LAST_DAY function with syntax and examples.
Description
The Oracle/PLSQL LAST_DAY function returns the last day of the month based on a date value.
Syntax
The syntax for the LAST_DAY function in Oracle/PLSQL is:
LAST_DAY( date )
Parameters or Arguments
- date
- The date value to use to calculate the last day of the month.
Returns
The LAST_DAY function returns a date value.
Applies To
The LAST_DAY function can be used in the following versions of Oracle/PLSQL:
- Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
Example
Let's look at some Oracle LAST_DAY function examples and explore how to use the LAST_DAY function in Oracle/PLSQL.
For example:
LAST_DAY(TO_DATE('2003/03/15', 'yyyy/mm/dd')) Result: Mar 31, 2003 LAST_DAY(TO_DATE('2003/02/03', 'yyyy/mm/dd')) Result: Feb 28, 2003 LAST_DAY(TO_DATE('2004/02/03', 'yyyy/mm/dd')) Result: Feb 29, 2004
Advertisements