MySQL DATE_FORMAT '%M' for short month?

Question

I'm trying to display dates like this `27-Jul-13`. I keep reading that `M` should give the shorthand month and `F` the full name. I am using this: ``` DATE_FORMAT(date, '%d-%M-%y') AS Displaydate ``` but it displays like this: `14-April-12` not `14-Apr-12` Also if I use `F` it doesn't work at all, it just displays an `F` where the month should be. What am I doing wrong?

Accepted Answer

According to `DATE_FORMAT` doc, you need `%b` for your format:

```
DATE_FORMAT(date, '%d-%b-%y') AS Displaydate
```

MySQL DATE_FORMAT '%M' for short month?

Solution

Problem