[RESOLVED] MYSQL Date Month question

[nickiehow]

In mysql, Select DATE_FORMAT(current_timestamp(), '%M %d %Y, %h:%i%p'), result is September 21 2005, 11:32AM.

How to change to Sep 21 2005, 11:32AM instead of September 21 2005, 11:32AM.

Can anyone advise me.

[nickiehow]

Found. it %b

[nickiehow]

Select DATE_FORMAT(current_timestamp(), '%d %d %Y, %h:%i%p') = Sep 21 2005, 11:32AM