Mysql Now Current DateTime

The Tutorial in this section illustrate an example from 'Mysql Now Current Date Time'.


 
Ads

Mysql Now Current DateTime

     

The Tutorial in this section illustrate an example from 'Mysql Now Current Date Time'. To understand and grasp an example we run a query now ( ) that return the current date  and time of your database.

 

 

 

 

 

Query:-

 mysql> select now()as CurrentDateTime;

Output:-

 +---------------------+
| CurrentDateTime   |
+---------------------+
| 2009-01-07 16:11:49 |
+---------------------+
1 row in set (0.03 sec)

Advertisements

Ads
Share on Google+Share on Google+

Mysql Now Current DateTime

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

Advertisements

 

Discuss: Mysql Now Current DateTime  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:1
sneha
May 15, 2012
date time

How to extract only date from NOW() function in MYSQL Server.??????

Ads

 

Ads