Big Data and Hadoop Training @$80 or Rs. 6,000 only - valid till Oct 17th Apply Now!

Mysql Date Now

Ads
 

Mysql Date Now

Date Now in Mysql is used to find out the current date and time.

Date Now in Mysql is used to find out the current date and time.

Mysql Date Now

     

Date Now in Mysql is used to find out the current date and time.

Understand with Example

The Tutorial illustrate an example from 'Mysql Date Now'. In this example we help you to find out the current date and time in Mysql. The Syntax below returns you the current date and time:

now ( ) :The now ( ) return you the current date and time in the field name Datenow.

Query:-

mysql> select now()as Datenow;

Output:-

+---------------------+
| Datenow             |
+---------------------+
| 2008-12-22 12:47:03 |
+---------------------+
1 row in set (0.00 sec)

Ads

Ads