Progress
SQL-92
Guide and Reference


LAST_DAY Function

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

SYNTAX

LAST_DAY ( date_expression ) 

EXAMPLE

This example illustrates the LAST_DAY function:

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

NOTES

COMPATIBILITY

Progress Extension


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095