The Tutorial illustrate an example from 'Sql Date Conversion'. To understand this, we show you an example that return you the specific format of date. This section shows you how to convert date :
'2008-12-04':-This is the date which is to be
%d:-Returns the date from the date you specified.
%M:-Returns the month name from the date you specified.
%Y:-Returns the Year from the date you specified.
|SELECT DATE_FORMAT('2008-12-04', "%d-%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