Quick Links to SQL Date and Time Functions
"C" Functions
CURRENT_DATE()
CURRENT_TIME()
CURRENT_TIMESTAMP()
CURDATE()
CURTIME()
"D" Functions
DAYNAME(date_exp)
DAYOFMONTH(date_exp)
DAYOFWEEK(date_exp)
DAYOFYEAR(date_exp)
"E" to "H" Functions
EXTRACT(extract-field FROM extract-source)
HOUR(time_exp)
"M" to "N" Functions
MINUTE(time_exp)
MONTH(date_exp)
MONTHNAME(date_exp)
NOW()
"Q" to "T" Functions
QUARTER(date_exp) SECOND(time_exp)
SECOND(time_exp)
TIMESTAMPADD(interval, integer_exp, timestamp_exp)
TIMESTAMPDIFF(interval, timestamp_exp1, timestamp_exp2)
"W" to "Y" Functions
WEEK(date_exp)
WEEKE1(date_exp)
WEEKE2(date_exp)
WEEKS(date_exp)
YEAR(date_exp)