title: DB2 SQL extract only month and year from date column
body: <p>I trying to <strong>group by</strong> month and year from MGMOV00F table - date column is DTMOMM, trying the syntax below but still getting error: argument 1 of function year not valid, anybody help please ? </p>
  
  <p><a href="https://i.stack.imgur.com/wMdaR.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wMdaR.jpg" alt="enter image description here"></a></p>