SQL: DATE_FORMAT()

In a nutshell

The DATE_FORMAT() function lets you format a date value based on a format string.

Syntax

DATE_FORMAT(date, format)

• date: The date or datetime value to format.
• format: The format string that defines the output format. This string can contain special date format specifiers that start with the % character.

Example

SELECT DATE_FORMAT('1993-07-12', '%W, %D %M %Y');
# Monday, 12th July 1993

Sources / related links

• DATE_FORMAT() – MySQL docs
• MySQL REPL – use this to play around with the different format specifiers.