NOW()

CURRENT_TIMESTAMP and NOW() both are synonymous.

Returns the current time as a value in hh:mm:ss or hhmmss format.

The value is expressed in the session time zone.

SELECT CURRENT_TIMESTAMP
SELECT NOW()

INSERT INTO t2 VALUES (CURRENT_TIMESTAMP);
INSERT INTO t1 VALUES (NOW());