How do I extract Month and Year in a MySQL date and compare them

Question

How do I extract the month and date from a mySQL date and compare it to another date   I found this MONTH   but it only gets the month  I looking for month and year

User · Answer

There should also be a YEAR     As for comparing  you could compare dates that are the first days of those years and months  or you could convert the year month pair into a number suitable for comparison  i e  bigger   later    Exercise left to the reader  For hints  read about the ISO date format    Or you could use multiple comparisons  i e  years first  then months

User · Answer

While it was discussed in the comments  there isn t an answer containing it yet  so it can be easy to miss  DATE FORMAT works really well and is flexible to handle many different patterns   DATE FORMAT date   Y m     To put it in a query   SELECT DATE FORMAT test date   Y m   AS date FROM test table

User · Answer

You may want to check out the mySQL docs in regard to the date functions  http   dev mysql com doc refman 5 5 en date-and-time-functions html  There is a YEAR   function just as there is a MONTH   function  If you re doing a comparison though is there a reason to chop up the date  Are you truly interested in ignoring day based differences and if so is this how you want to do it

User · Answer

If you are comparing between dates  extract the full date for comparison  If you are comparing the years and months only  use  SELECT YEAR date  AS  year   MONTH date  AS  month   FROM Table Where Condition    Condition

User · Answer

in Mysql Doku   http   dev mysql com doc refman 5 5 en date-and-time-functions html function extract  SELECT EXTRACT  YEAR MONTH FROM  date     FROM  Table  WHERE Condition    Condition

User · Answer

SELECT   FROM Table name Where Month date   10   amp  amp  YEAR date   2016

[mysql] How do I extract Month and Year in a MySQL date and compare them?

Examples related to mysql

Examples related to sql

Examples related to date