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

As the name suggests CURDATE() function will return the current date. In simple words, we can say that it would return only the date not time.

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

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

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

Prabhas

Published on 19-Feb-2018 07:25:29

• Related Questions & Answers
• What is the difference between MySQL NOW() and SYSDATE()?
• CURDATE () vs NOW() in MySQL
• What is the difference between MySQL LENGTH() and CHAR_LENGTH() function?
• What is the difference between MySQL stored procedure and function?
• What is the difference between MySQL ISNULL() function and IS NULL operator?
• What is the significant difference between MySQL TRUNCATE() and ROUND() function?
• What is the difference between SQL and MySQL?
• How can I use INTERVAL keyword with MySQL NOW() and CURDATE() functions?
• How to make MySQL's NOW() and CURDATE() functions use UTC?
• What is the difference between a method and a function?
• What is the difference between CHAR and NCHAR in MySQL?
• What is the difference between CHAR and VARCHAR in MySQL?
• What is the difference between MySQL INSTR() and FIND_IN_SET() functions?
• What is the difference between UNIX TIMESTAMPS and MySQL TIMESTAMPS?
• What is the difference between MySQL LOCATE() and FIND_IN_SET() functions?