MySQL: Curdate () vs Now ()

Question

What is the difference between MySQL Curdate() and Now() ?

Answer 1

For such questions, you should always take a look at the manual first. Date and time functions in the mySQL manual

CURDATE() returns the DATE part of the current time. CURDATE () Guide

NOW() returns the parts of the date and time as a timestamp in various formats, depending on how it was requested. Manual on NOW () .

Answer 2

Just for fun:

 CURDATE() = DATE(NOW()) 

or

 NOW() = CONCAT(CURDATE(), ' ', CURTIME()) 

Answer 3

CURDATE() will give the current date, and NOW() will give the full time.

Run the queries and you will find out what is the difference between them.

 SELECT NOW(); -- You will get 2010-12-09 17:10:18 SELECT CURDATE(); -- You will get 2010-12-09 

Answer 4

In fact, MySQL provides many convenient functions in everyday life without any effort on the part of the user -

NOW () it creates the date and time as in the current script, whereas CURDATE () is only the release date, CURTIME () , we can use one of them according to our need with CAST or merge others to calculate it, MySQL is rich in these types of functions .

NOTE. - . You can see the difference using the select NOW () query as NOWDATETIME, CURDATE () as NOWDATE, CURTIME () as NOWTIME;