Mysql Date no Time

The Tutorial illustrate an example 'Date no Time' in Mysql . In this Example, the date(now( ) ) return you the current date with no time.

Mysql Date no Time

     

Mysql Date no Time is used to find out the current date with no time.

Understand with Example

The Tutorial illustrate an example 'Date no Time' in Mysql . In this Example, the date(now( ) ) return you the current date  with no time.

date(now( ) ) : The date(now( ))  return you the current year, month and 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 no Time

Posted on: January 20, 2009 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

 

Discuss: Mysql Date no Time  

Post your Comment


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

Ads

 

Ads