LAST_DAY

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

Syntax

LAST_DAY ( date_expression )

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.

This example illustrates the LAST_DAY function:

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

Progress extension