Table of Contents

Search

  1. Preface
  2. Function reference
  3. Constants
  4. Operators
  5. Dates
  6. Functions
  7. System variables
  8. Datatype reference

Function Reference

Function Reference

LAST_DAY

LAST_DAY

Returns the date of the last day of the month for each date in a column.

Syntax

LAST_DAY(
date
)
Argument
Required/
Optional
Description
date
Required
Date/Time datatype. Passes the dates for which you want to return the last day of the month. You can enter any valid expression that evaluates to a date.

Return Value

Date. The last day of the month for that date value you pass to this function.
NULL if a value in the selected column is NULL.

Null

If a value is NULL, LAST_DAY ignores the row. However, if all values passed from the column are NULL, LAST_DAY returns NULL.

Example

The following expression returns the last day of the month for each date in the ORDER_DATE column:
LAST_DAY( ORDER_DATE )
ORDER_DATE
RETURN VALUE
Apr 1 1998 12:00:00AM
Apr 30 1998 12:00:00AM
Jan 6 1998 12:00:00AM
Jan 31 1998 12:00:00AM
Feb 2 1996 12:00:00AM
Feb 29 1996 12:00:00AM   
(Leap year)
NULL
NULL
Jul 31 1998 12:00:00AM
Jul 31 1998 12:00:00AM
You can nest TO_DATE to convert string values to a date. TO_DATE always includes time information. If you pass a string that does not have a time value, the date returned will include the time 00:00:00.
The following example returns the last day of the month for each order date in the same format as the string:
LAST_DAY( TO_DATE( ORDER_DATE, 'DD-MON-YY' ))
ORDER_DATE
RETURN VALUE
'18-NOV-98'
Nov 30 1998 00:00:00
'28-APR-98'
Apr 30 1998 00:00:00
NULL
NULL
'18-FEB-96'
Feb 29 1996 00:00:00
(Leap year)

0 COMMENTS

We’d like to hear from you!