对日期进行相加
DATE_ADD(date,INTERVAL expr unit)
SELECT DATE_ADD(now(),INTERVAL '3' MONTH);
3: 数字 MONTH :type
select WEEK(CURRENT_DATE) ;
select YEAR(CURRENT_DATE) ;
SELECT HOUR(CURRENT_TIME);
SELECT CURRENT_TIME, MINUTE(CURRENT_TIME);
时间戳
SELECT UNIX_TIMESTAMP(NOW());
SELECT FROM_UNIXTIME(1539744107)