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');|
If you enjoyed this post then why not add us on Google+? Add us to your Circles
Liked it! Share this Tutorial
Discuss: Mysql Date Format
Post your Comment