Progress
SQL-92
Guide and Reference


ADD_MONTHS Function

Adds to the date value specified by the date_expression, the given number of months specified by integer_expression, and returns the resultant date value.

SYNTAX

ADD_MONTHS ( date_expression , integer_expression ) 

EXAMPLE

This example illustrates the ADD_MONTHS function:

SELECT * 
    FROM  customer
    WHERE ADD_MONTHS (start_date, 6) > SYSDATE ; 

NOTES

COMPATIBILITY

Progress Extension


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