CODE EXAMPLE FOR SQL

sql convert datetime to year month

    DATE_FORMAT(_column, '%Y-%m')AS `yyyy-mm`,