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.

Ads

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

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

Ads
 

Discuss: Mysql Date no Time  

Post your Comment


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

Ads

 

Ads