date now myysql code example

Example 1: mysql current date

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

Example 2: query current time

CURRENT_TIMESTAMP