Selecting Date from a Mysql field in specific format

I had a membership table with users and the datetime at which they
joined the site. I needed to get a count of members joining per month,
so I did this:

<br />
SELECT DATE_FORMAT( regdate, '%b %Y' ) <br />
AS<br />
MONTH , count( uid ) AS Users <br />
FROM gl_users <br />
GROUP BY MONTH  LIMIT 0 , 30<br />

Which resulted in

SQL result

SQL-query: SELECT DATE_FORMAT( regdate, ‘%b %Y’ ) AS
MONTH , count( uid ) AS Users
FROM gl_users
GROUP BY MONTH LIMIT 0, 30;

And here are some more resources that I found.

http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html

http://www.sitepoint.com/forums/archive/index.php/t-164068

http://www.databasejournal.com/features/mysql/article.php/10897_2190421_2