[RESOLVED] Date Format Issue

[Twilite_Kid_82]

Hey im trying to display a date like

Mar 14, 2007 with the 3 letter abbreviated month

but it keeps displaying March 14, 2007

here is the code I used...

SELECT DATE_FORMAT(date, '%M %e, %Y')

thanks 🙂

[Twilite_Kid_82]

SELECT DATE_FORMAT(date, '%b %d, %Y')

fixed the problem 🙂