Easy Tutorial
❮ Sql Func Min Func Datediff Mysql ❯

MySQL DATE_FORMAT() Function



Definition and Usage

The DATE_FORMAT() function is used to display date/time data in different formats.

Syntax

The date parameter is a valid date. The format specifies the output format of the date/time.

The available formats are:

Format Description
%a Abbreviated weekday name
%b Abbreviated month name
%c Month, numeric
%D Day of the month with English suffix
%d Day of the month, numeric (00-31)
%e Day of the month, numeric (0-31)
%f Microseconds
%H Hour (00-23)
%h Hour (01-12)
%I Hour (01-12)
%i Minutes, numeric (00-59)
%j Day of the year (001-366)
%k Hour (0-23)
%l Hour (1-12)
%M Month name
%m Month, numeric (00-12)
%p AM or PM
%r Time, 12-hour (hh:mm:ss AM or PM)
%S Seconds (00-59)
%s Seconds (00-59)
%T Time, 24-hour (hh:mm:ss)
%U Week (00-53) where Sunday is the first day of the week
%u Week (00-53) where Monday is the first day of the week
%V Week (01-53) where Sunday is the first day of the week, used with %X
%v Week (01-53) where Monday is the first day of the week, used with %x
%W Weekday name
%w Day of the week (0=Sunday, 6=Saturday)
%X Year where Sunday is the first day of the week, 4 digits, used with %V
%x Year where Monday is the first day of the week, 4 digits, used with %v
%Y Year, 4 digits
%y Year, 2 digits

Example

The following script uses the DATE_FORMAT() function to display different formats. We use NOW() to get the current date/time:

The result is shown below:


❮ Sql Func Min Func Datediff Mysql ❯