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?
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