MySQL Date and Time Functions

Function Usage Returns
DATE() DATE(dt) The date value of dt
HOUR() HOUR(dt) The hour value value of dt
MINUTE() MINUTE(dt) The minute value of dt
SECOND() SECOND(dt) The second value of dt
DAYNAME() DAYNAME(dt) The name of the day for dt
DAYOFMONTH() DAYOFMONTH(dt) The numerical day value for dt
MONTH() MONTH(dt) The numerical month value of dt
YEAR() YEAR(column) The year value of dt
CURDATE() CURDATE() The current date
CURTIME() CURTIME() The current time
NOW() NOW() The current date and time
UNIX_TIMESTAMP() UNIX_TIMESTAMP(dt) The number of seconds since the epoch until the current moment or until the date specified
UTC_TIMESTAMP UTC_TIMESTAMP(dt) The number of seconds since the epoch until the current moment or until the date specified in, in Coordinated Universal Time (UTC)