Mysql Date Format

The different types of time data in MySQL :TIME, DATE TIME and TIMESTAMP. The Tutorial helps you to write the Date Format in SQL Query.

Mysql Date Format

     

The different types of time data in MySQL :TIME, DATE TIME and TIMESTAMP. The Tutorial helps you to write the Date Format in SQL Query. 

date_format(now( ),'%e %M%W%Y') : This Query is used to display the current date, month, week and year. 

Query for formatting currentdate:-

mysql> select date_format(now(),'%e %M %W %Y');

Output:-

+----------------------------------+
| date_format(now(),'%e %M %W %Y') |
+----------------------------------+
| 20 December Saturday 2008 |
+----------------------------------+
1 row in set (0.00 sec)

Advertisements

Ads
Share on Google+Share on Google+

Mysql Date Format

Posted on: April 3, 2006 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

Ads
 

Discuss: Mysql Date Format  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:1
Happy
December 13, 2011
PKAnqFktWiwTm

A few years ago I'd have to pay somenoe for this information.

Ads

 

Ads