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)
|

|