month year and date from sql datetime code example

Example: sql convert datetime to year month

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