MONTHSBTWN

Restriction: This topic applies to Windows environments only.
ANSI DB2 SQL/DS XDB
      X

This function is used to obtain the difference between dates in months. The format appears below:

MONTHSBTWN(date1,date2)

For example:

MONTHSBTWN(07/24/1991,10/13/1991) = 3
Parent topic: Date And Time Functions (XDB Mode)