时间函数¶
本节的时间指广义上的时间，包括DATE、TIME、TIME WITH TIME ZONE、TIMESTAMP、TIMESTAMP WITH TIME ZONE、INTERVAL YEAR TO MONTH、INTERVAL DAY TO SECOND类型。时间函数都接收时间类型参数，返回值大多也为时间类型，但部分函数可能会返回整型或其它类型。每个时间函数的详细说明请参见下面的介绍。
- AGE
- CURDATE
- CURTIME
- CURTIMESTAMP
- DATEPART
- DATE_PART
- DATE_TRUNC
- DATEADD
- DATEDIFF
- DAYS
- DAYNAME
- DAYOFMONTH
- DAYOFWEEK
- DAYOFYEAR
- EXTRACT
- GETDATE
- HOUR
- ISFINITE
- MINUTE
- MONTH
- MONTHNAME
- NOW
- QUARTER
- SECOND
- SYSDATETIME
- TIMEOFDAY
- TIMESTAMPADD
- TIMESTAMPDIFF
- WEEK
- YEAR
- TIMESTAMP_SMALLER
- TIMESTAMP_LARGER
- TIME_LARGER
- TIME_SMALLER
- DATE_SMALLER
- DATE_LARGER
- DATE_FORMAT
- OVERLAPS
- DATE_PLI
- DATE_MII
- MONTHNAME_C
- DAYNAME_C
- DATE_MI
- YEARWEEK
- DAYOFWEEK_ISO
- NEXT_DAY
- MONTHS_BETWEEN
- JULIAN
- MIDNIGHT_SECONDS
- FROM_DAYS
- FROM_TZ
- GET_TZ
- GETDATE
- GETUTCDATE
- NUMTOYMINTERVAL
- NUMTODSINTERVAL
- INTERVALYTM_CMP
- TIMEZONE
- TIMESTAMP_CMP
- INTERVALDTS_CMP
- TIMESTAMP_SMALLER
- TIMESTAMP_LARGER
- INTERVALYTM_LARGER
- INTERVALYTM_SMALLER
- INTERVALDTS_SMALLER
- INTERVALDTS_LARGER
- ISDATE
- TO_DAYS
- FROM_UNIXTIME
- UNIX_TIMESTAMP