hwo to get current data and time in mysql code example

Example: mysql current date

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