Progress
SQL-92
Guide and Reference


MONTHS_BETWEEN Function

Computes the number of months between two date values corresponding to the first and second arguments.

SYNTAX

MONTHS_BETWEEN ( date_expression, date_expression ) 

EXAMPLE

This example illustrates the MONTHS_BETWEEN function:

SELECT MONTHS_BETWEEN (SYSDATE, order_date) 
    FROM orders
    WHERE order_no = 1002 ; 

NOTES

COMPATIBILITY

Progress Extension


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