mysql system date time now vs code example

Example 1: get date from now() mysql

You can use CURDATE()

Example 2: mysql current date

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