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



Home Sql Sqldate Mysql Date Format

Related Tutorials


 
 

Share on Google+Share on Google+

Mysql Date Format

Advertisement
Mysql Date Format explains you the way of formatting Date.

Mysql Date Format

     

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 :

SYNTAX:-DATE_FORMAT(date,format)

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

Query:-

SELECT DATE_FORMAT('2008-12-15', '%W %e %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: Mysql Date Format  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:1
Rudina
August 25, 2012
KGujPscZzPvZIvUC

this is our price plan detailEcvps-120GB Diskspace500GB BandwidthOnly For $ 10/month now with $5 first month or 10% off eymevronthEcvps-240 GB Diskspace1000 GB BandwidthOnly For $ 19/month now with 9.5 first month or 10% off eymevronthEcvps-380 GB Diskspace1500 GB BandwidthOnly For $35/month now with 17.5 first month or 10% off eymevronth50%off half price for first month10%OFF 10%off eymevronth (Recurring )And this are including basic managmentand if you are looking for more plan, please go to ecvps.com/client/cart.phpHow about our network?We are using dallas ( softlayer )FAQQ: Do you oversell our Resources?A: We Never oversell our server resources, so that mean, if you buy our vps hosting, you will be able to use all of your web space, Bandwidth etc.Q: Do you allow IRC?A: YesQ: Do you allow any adult content?A: Yes, but it must be legal.Q: If I have a problem with control panel, e.g. setup a mysql, ftp etc, what can I do?A: We are always here, please don't be shy to contact us.Q: How long does it take for my vps setup?A: It usually takes few minutes to setup, if you wait for up to an hour, but the vps still not setup, please contact us.Q: I would like to apply the free trial account , what can I do?A: Simple to email us or find us on the front page ( web chat )Q: May I have more detail of free trial account ?A: Free trial account goes with one Dedicated IP, and 3 days for free, after 3 days, if you would like to join us, we won't delete your vps account.Q: How many servers have ECVPS got at this moment?A: We got three servers at this moment, two are using softlayer ( Dallas ), one with using FDCserver ( Chicago ), but two of the Dallas's server are using Xeon + 8GB ram, only the Chicago not. So we strongly recommend our customers to use Dallas server. By the default, all customers will be use Dallas.If this detail not solve your problem, please go to our website to contact us.And again, please don't be shy, we are here to help all of you!Thanksecvps.com
DMCA.com