eharetea

MySQL time and date functions. .

Date and time in MySQL.

Date Created:Friday December 29th, 2006 03:41 AM
Date Modified:Friday August 01st, 2008 01:04 AM

some date and time functions:

HOUR(date_column)
MINUTE(date_column)
SECOND(date_column)
DAYNAME(date_column)
MONTHNAME(date_column)
DAY(date_column)
CURDATE()
CURTIME()
NOW()
UNIX_TIMESTAMP(date_column)
ADDDATE()
SUBDATE()
TIMEFORMAT()
DATEFORMAT()

usage:

SELECT DAYNAME(registration_date) from users;