SQL

mysql select month and year

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

mysql select by month

SELECT * FROM Project WHERE MONTH(DueDate) = 1 AND YEAR(DueDate) = 2010

How to Get the Year and the Month From a Date in MySQL

SELECT
YEAR(date) AS year,
MONTHNAME(date) AS month
FROM dates;