month in mysql date 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");