%b: Abbreviated month name (Jan..Dec) : DATE_FORMAT « Date Time Functions « MySQL Tutorial

mysql> SELECT DATE_FORMAT('1997-10-04 22:23:00', '%b');
+------------------------------------------+
| DATE_FORMAT('1997-10-04 22:23:00', '%b') |
+------------------------------------------+
| Oct                                      |
+------------------------------------------+
1 row in set (0.00 sec)

mysql>

14.11.DATE_FORMAT
	14.11.1.	DATE_FORMAT()
	14.11.2.	Dates can also be formatted in 'plain english'
	14.11.3.	Using DATE_FORMAT() with an alias to tidy up the title
	14.11.4.	%a: Abbreviated weekday name (Sun..Sat)
	14.11.5.	%b: Abbreviated month name (Jan..Dec)
	14.11.6.	%c: Month, numeric (0..12)
	14.11.7.	%D: Day of the month with English suffix (0th, 1st, 2nd, 3rd, ...)
	14.11.8.	%d: Day of the month, numeric (00..31)
	14.11.9.	%e: Day of the month, numeric (0..31)
	14.11.10.	%f: Microseconds (000000..999999)
	14.11.11.	%H: Hour (00..23)
	14.11.12.	%h: Hour (01..12)
	14.11.13.	%I: Hour (01..12)
	14.11.14.	%i: Minutes, numeric (00..59)
	14.11.15.	%j: Day of year (001..366)
	14.11.16.	%k: Hour (0..23)
	14.11.17.	%l: Hour (1..12)
	14.11.18.	%M: Month name (January..December)
	14.11.19.	%m: Month, numeric (00..12)
	14.11.20.	%p: AM or PM
	14.11.21.	%r: Time, 12-hour (hh:mm:ss followed by AM or PM)
	14.11.22.	%S: Seconds (00..59)
	14.11.23.	%T: Time, 24-hour (hh:mm:ss)
	14.11.24.	%U: Week (00..53), where Sunday is the first day of the week
	14.11.25.	%u: Week (00..53), where Monday is the first day of the week
	14.11.26.	%V: Week (01..53), where Sunday is the first day of the week; used with %X
	14.11.27.	%v: Week (01..53), where Monday is the first day of the week
	14.11.28.	%W: Weekday name (Sunday..Saturday)
	14.11.29.	%w: Day of the week (0=Sunday..6=Saturday)
	14.11.30.	%X: Year for the week where Sunday is the first day of the week, numeric, four digits
	14.11.31.	%x: Year for the week, where Monday is the first day of the week, numeric, four digits
	14.11.32.	%Y: Year, numeric, four digits
	14.11.33.	%y: Year, numeric (two digits)
	14.11.34.	%%: A literal '%' character
	14.11.35.	SELECT DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
	14.11.36.	SELECT DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');
	14.11.37.	SELECT DATE_FORMAT('1997-10-04 22:23:00','%D %y %a %d %m %b %j');
	14.11.38.	SELECT DATE_FORMAT('1997-10-04 22:23:00','%H %k %I %r %T %S %w');
	14.11.39.	SELECT DATE_FORMAT('1999-01-01', '%X %V');
	14.11.40.	SELECT DATE_FORMAT('2006-06-00', '%d');