QUARTER

ANSI DB2 SQL/DS XDB
      X

This function is used to obtain the numeric value (1-4) of the quarter in which the date resides. The format appears below:

QUARTER(date)

For example:

QUARTER(2/14/1991) = 1
QUARTER(5/14/1991) = 2