Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. Get the current full date object, current date nd time
mysql>
mysql> SELECT NOW(), CURDATE(), CURTIME();
+---------------------+------------+-----------+
| NOW()               | CURDATE()  | CURTIME() |
+---------------------+------------+-----------+
| 2011-10-04 11:09:17 | 2011-10-04 | 11:09:17  |
+---------------------+------------+-----------+
1 row in set (0.00 sec)