What is the difference between MySQL NOW() and CURDATE() functions?

As its name suggests, the CURDATE() function will return the current date. Simply put, it only returns the date, not the time.

mysql> select CURDATE();
+------------+
| CURDATE()  |
+------------+
| 2017-10-28 |
+------------+
1 row in set (0.00 sec)

In contrast, the NOW() function will return the current date and time.

mysql> Select NOW();
+---------------------+
| NOW()               |
+---------------------+
| 2017-10-28 09:10:16 |
+---------------------+
1 row in set (0.00 sec)

The above is the detailed content of What is the difference between MySQL NOW() and CURDATE() functions?. For more information, please follow other related articles on the PHP Chinese website!