Mysql Date Now

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

Mysql Date Now

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)