Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Sql Sqldate Sql Date Conversion

Related Tutorials


 
 

Share on Google+Share on Google+

Sql Date Conversion

Advertisement
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

Sql Date Conversion

     

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 converted.

%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.

Query:-

SELECT DATE_FORMAT('2008-12-04', "%d-%M-%Y");

Output:-

Advertisements

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: December 31, 2008

Related Tutorials

Discuss: Sql Date Conversion  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:0
DMCA.com