MySQL: Curdate() vs Now()

datetime, mysql, sql

Solution

For questions like this, it is always worth taking a look in the manual first. Date and time functions in the mySQL manual

`CURDATE()` returns the DATE part of the current time. Manual on CURDATE()

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

Problem

Original source