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');|
Rs. 20,000 US$ 300
Today: Rs. 10,000 US$150
Course Duration: 30 hrs
Posted on: December 31, 2008 If you enjoyed this post then why not add us on Google+? Add us to your Circles