totn Oracle Functions

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