how to get the system date in mysql code example

Example: mysql current date

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