sajad torkamani

In a nutshell

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


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.


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

Sources / related links

Tagged: MySQL