mysql datetime now code example

Example 1: mysql now format

SELECT DATE_FORMAT(NOW(),'%Y-%m-%d %H-%i-%s')

Example 2: get date from now() mysql

You can use CURDATE()

Example 3: mysql current date

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

Example 4: mysql current time

CURRENT_TIME return HH:ii:ss format time in mysql

Example 5: query current time

CURRENT_TIMESTAMP