Mysql Date Format explains you the way of formatting Date.
Understand with Example
The Tutorial elaborate an example from 'Mysql Date Format'. To understand this example we show you the following Syntax used for formatting the date :
date:-This is the date which is to been formatted.
format:-The format specifier used here are
%W:- This is used for showing weekday name i.e(Sunday-Saturday).
%e:- This is used for showing Day of the month, numeric (0-31).
%M :- This is used for showing Month name (January-December)
%Y:- This is used for showing Year, numeric, four digits
|SELECT DATE_FORMAT('2008-12-15', '%W %e %M %Y');|
Liked it! Share this Tutorial