CODE EXAMPLE FOR SQL

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

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