Mysql Date Part Only

Sometimes we want to see the date part only from the records of a table.

Ads

Mysql Date Part Only

     

Sometimes we want to see the date part only from the records of a table. The Tutorial covers you an example that helps you to get date part. The date(now( )) return you the current date as date field name.

date (now( ) ) : The date(now ( )) return you the current date. 

Query:-

 

 

 

mysql> select date(now())as date;

Output:-

+------------+
| date       |
+------------+
| 2008-12-22 |
+------------+
1 row in set (0.00 sec)

Advertisements

Ads
Share on Google+Share on Google+

Mysql Date Part Only

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

Advertisements

Ads
 

Discuss: Mysql Date Part Only  

Post your Comment


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

Ads

 

Ads