mysql where month and year code example
Example 1: mysql select month and year
SELECT DATE_FORMAT(test_date,'%Y%m') AS date FROM test_table;
Example 2: month mysql
SELECT MONTH("2017-06-15");
SELECT DATE_FORMAT(test_date,'%Y%m') AS date FROM test_table;
SELECT MONTH("2017-06-15");