mysql check what currentdate function returns code example

Example: mysql current date

SELECT NOW();
It returns current date and time.