Check Date and Time in mysql

Sometimes we may need to check the time when we are working with mysql.
To do this login to mysql and use the following command

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2010-09-28 14:49:57 |
+---------------------+
1 row in set (0.06 sec)