1.
2.DAYOFWEEK(date)
3.WEEKDAY(date)
4.DAYOFMONTH(date)
5.DAYOFYEAR(date)
6.MONTH(date)
7.DAYNAME(date)
8.MONTHNAME(date)
9.QUARTER(date)
10.WEEK(date)
WEEK(date,first)
11.YEAR(date)
12.HOUR(time)
13.MINUTE(time)
14.SECOND(time)
15.PERIOD_ADD(P,N)
16.PERIOD_DIFF(P1,P2)
17.DATE_ADD(date,INTERVAL expr
相关下载链接:
//download.csdn.net/download/itorac/2550214?utm_source=bbsseo