Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. CURDATE(), CURRENT_DATE(), CURTIME(), CURRENT_TIME(), CURRENT_TIMESTAMP(), and NOW() Functions
mysql>
mysql>
mysql> SELECT CURDATE();
+------------+
| CURDATE()  |
+------------+
| 2011-10-03 |
+------------+
1 row in set (0.00 sec)
mysql> SELECT CURTIME();
+-----------+
| CURTIME() |
+-----------+
| 20:56:41  |
+-----------+
1 row in set (0.00 sec)
mysql> SELECT NOW();
+---------------------+
| NOW()               |
+---------------------+
| 2011-10-03 20:56:41 |
+---------------------+
1 row in set (0.00 sec)
mysql>