MySQL: using YEAR_MONTH

Issue

phpmyAdmin suggested an autocompleted function YEAR_MONTH() in the Query Editor that I can’t find anywhere online. It would be awesome if this function existed.

Does it? If yes, how would one use it?

Solution

While it isn’t a valid function, YEAR_MONTH is valid SQL. For instance:

SELECT EXTRACT(YEAR_MONTH FROM '2009-07-02 01:02:03');

See also the discussion at https://github.com/phpmyadmin/phpmyadmin/issues/11877

Answered By – Isaac Bennetch

This Answer collected from stackoverflow, is licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply

(*) Required, Your email will not be published