mysql show datetime code example

Example 1: mysql now format

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

Example 2: mysql current time

CURRENT_TIME return HH:ii:ss format time in mysql