mysql todays date and time yyyymmdd hhmmss code example

Example: mysql current date

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