mysql get this year and month code example
Example 1: mysql select month and year
SELECT DATE_FORMAT(test_date,'%Y%m') AS date FROM test_table;
Example 2: mysql get year from date
YEAR(my_date)
SELECT DATE_FORMAT(test_date,'%Y%m') AS date FROM test_table;
YEAR(my_date)