extract date from now in mysql code example

Example: get date from now() mysql

You can use CURDATE()