MySQL DATE_FORMAT() Function Format Specifiers
This list of formats used in this function are listed below
| Format | Description |
|---|---|
| %a | This abbreviation means weekday name. It’s limit is from Sun to Sat. |
| %b | This abbreviation means month name. It’s limit is from Jan to Dec. |
| %c | This abbreviation means numeric month name. It’s limit is from 0 to 12. |
| %D | This abbreviation means day of the month as a numeric value, followed by suffix like 1st, 2nd, etc. |
| %e | This abbreviation means day of the month as a numeric value. It’s limit is from 0 to 31. |
| %f | This abbreviation means microseconds. It’s limit is from 000000 to 999999. |
| %H | This abbreviation means hour. It’s limit is from 00 to 23. |
| %i | This abbreviation means minutes. It’s limit is from 00 to 59. |
| %j | This abbreviation means day of the year. It’s limit is from 001 to 366. |
| %M | This abbreviation means month name from January to December. |
| %p | This abbreviation means AM or PM. |
| %S | This abbreviation means seconds. It’s limit is from 00 to 59. |
| %U | This abbreviation means week where Sunday is the first day of the week. It’s limit is from 00 to 53. |
| %W | This abbreviation means weekday name from Sunday to Saturday. |
| %Y | This abbreviation means year as a numeric value of 4-digits. |
MySQL DATE_FORMAT() Function
MySQL DATE_FORMAT() function formats a specified date to a given format value.
Contact Us