How to extract month and year from MySQL?

Question

Here is my query SELECT EXTRACT(YEAR_MONTH FROM <date>) FROM <table>;

Output of this query is 201309

But how to get it like Sep-2013 , and that too as a date?

Answer 1

SELECT date_format(curdate(), '%b-%Y')

DATEFORMAT()

SQLFiddle demo

Answer 2

SELECT CONCAT(MONTHNME(<date>), "-", YEAR(<date>)  FROM <table>;