special date and time code example

Example: special date and time

MySQL Date and Time Functions
DAYOFWEEK
DATE_SUB
WEEKDAY
ADDDATE
DAYOFMONTH
SUBDATE
DAYOFYEAR
EXTRACT
MONTH
TO_DAYS
DAYNAME
FROM_DAYS
MONTHNAME
DATE_F­ORMAT
QUARTER
TIME_F­ORMAT
WEEK
CURREN­T_DATE
YEAR
CURREN­T_TIME
YEARWEEK
NOW
HOUR
SYSDATE
MINUTE
UNIX_T­IME­STAMP
SECOND
FROM_U­NIXTIME
PERIOD_ADD
SEC_TO­_TIME
PERIOD­_DIFF
TIME_T­O_SEC
DATE_ADD