Returns the date corresponding to the last day of the month containing the argument date.

Syntax

LAST_DAY ( date_expression )

Notes

  • The argument to the function must be of type DATE.
  • The result is of type DATE.
  • If the argument expression evaluates to NULL, the result is NULL.

Example

This example illustrates the LAST_DAY function:

SELECT *
    FROM orders
    WHERE LAST_DAY (order_date) + 1 = '08/01/2003' ;

Compatibility

Progress extension