Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Functions : LAST_DAY
 

LAST_DAY

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