Check out example codes for "mysql select month and year". It will help you in understanding the concepts better.

Code Example 1

SELECT DATE_FORMAT(test_date,'%Y%m') AS date FROM test_table;

Learn ReactJs, React Native from akashmittal.com