DB2 SQL extract only month and year from date column
06:22 07 Jun 2016

I trying to group by 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 ?

enter image description here

sql database date db2