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
EXAMPLE
This example illustrates the MONTHS_BETWEEN function:
NOTES
- The first and second arguments to the function must be of type DATE.
- The result is of type INTEGER.
- The result is negative if the date corresponding to the second argument is greater than that corresponding to the first argument.
- If any of the argument expressions evaluates to null, the result is null.
COMPATIBILITY
Progress Extension
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |