MONTHBEG

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

This function is used to extract the first day of the month the date resides in. The format appears below:

MONTHBEG(date)

For example:

MONTHBEG(2/14/1991) = 2/1/1991
Parent topic: Date And Time Functions (XDB Mode)