sajad torkamani

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

Tagged: MySQL

Leave a comment

Your email address will not be published. Required fields are marked *