Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. Determining the Current Date or Time
mysql>
mysql> SELECT NOW( ), CURDATE( ), CURTIME( );
+---------------------+------------+------------+
| NOW( )              | CURDATE( ) | CURTIME( ) |
+---------------------+------------+------------+
| 2011-10-03 13:05:45 | 2011-10-03 | 13:05:45   |
+---------------------+------------+------------+
1 row in set (0.00 sec)
mysql>