Mysql Date now function

Mysql Date now function is useful when you want to return the current time and date .

Mysql Date now function

Mysql Date now function

     

Mysql Date now function is useful when you want to return the current time and date .

Understand with Example

The Tutorial illustrate an example from 'Mysql Date now function'. In this Tutorial we define a now ( ) Query that return you the current date and time.

now ( ) : The now ( ) function return you the current date and time as DatenowFunction.

Query:-

mysql> select now()as DatenowFunction;

Output:-

+---------------------+
| DatenowFunction     |
+---------------------+
| 2008-12-22 13:05:44 |
+---------------------+
1 row in set (0.20 sec)