mysql current time
snippet in sql

mysql get date from datetime

user8016

WHERE DATE(datetime) = '2009-10-20'

mysql current date

user5495

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

mysql current time

user4292

CURRENT_TIME return HH:ii:ss format time in mysql