Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. To find out what date it is, according to the server, you can use the CURRENT_DATE() function
mysql>
mysql>
mysql> SELECT NOW(),CURRENT_DATE();
+---------------------+----------------+
| NOW()               | CURRENT_DATE() |
+---------------------+----------------+
| 2011-10-04 09:21:37 | 2011-10-04     |
+---------------------+----------------+
1 row in set (0.00 sec)