Get today's date in (YYYY-MM-DD) format in MySQL

Question

I need to get today's date in YYYY-MM-DD format.

Any ideas? Using NOW() I'm getting hours, minutes and seconds too...

Answer 1

It's as simple as

SELECT CURDATE();

Documentation link.

Answer 2

SELECT DATE(NOW())

will work for you :)

The DATE function converts a datetime into a date.