To find out what date it is, according to the server, you can use the CURRENT_DATE() function : CURDATE « Date Time « SQL / MySQL






  1. SQL / MySQL
  2. Date Time
  3. CURDATE

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)








Related examples in the same category

1.CURDATE(), CURRENT_DATE(), CURTIME(), CURRENT_TIME(), CURRENT_TIMESTAMP(), and NOW() Functions
2.Determining the Current Date or Time
3.Check current date in where clause