turn date into only year and month in sql code example Example: sql convert datetime to year month DATE_FORMAT(_column, '%Y-%m')AS `yyyy-mm`,