Get the current date using MySQL

SELECT NOW();
(OR)
SELECT CURDATE();
(OR)
SELECT CURRENT_DATE();