[FIXED] 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