![4b53b547bd76bfa9d650ccf64dde6fe0.png](https://img-blog.csdnimg.cn/img_convert/4b53b547bd76bfa9d650ccf64dde6fe0.png)
1.获得系统时间 函数:now()
SELECT NOW() AS '系统时间';
![6dea84570b332cd56bf9a538ce680938.png](https://img-blog.csdnimg.cn/img_convert/6dea84570b332cd56bf9a538ce680938.png)
2.获得当前时间戳函数:current_timestamp
SELECT current_timestamp
![c9f7c13b97251b4ea82e5523c4fe80c3.png](https://img-blog.csdnimg.cn/img_convert/c9f7c13b97251b4ea82e5523c4fe80c3.png)
日期转换函数、时间转换函数
3.(日期/时间转换为字符串)函数:date_format(date,format); time_format(time,format)
SELECT DATE_FORMAT(NOW(), '%Y%m%d%H%i%s');
![1ca48aa0a0fbc7727183c8c0b8f802b1.png](https://img-blog.csdnimg.cn/img_convert/1ca48aa0a0fbc7727183c8c0b8f802b1.png)
SELECT TIME_FORMAT(NOW(), '%H:%i:%s');
![384718cd3a061b3ea0e4c5d9546f96e7.png](https://img-blog.csdnimg.cn/img_convert/384718cd3a061b3ea0e4c5d9546f96e7.png)
4.(字符串转换为日期)函数:str_to_date(str, format)
SELECT STR_TO_DATE('2019.07.01', '%Y.%m.%d') AS '格式时间';
![6ef8083b661b874c9c18363088ba247d.png](https://img-blog.csdnimg.cn/img_convert/6ef8083b661b874c9c18363088ba247d.png)
5.(日期、天数)转换函数:to_days(date), from_days(days)
SELECT TO_DAYS('2019-06-10') AS '天数'
![88e624332c10ec0b11e4758e16849edd.png](https://img-blog.csdnimg.cn/img_convert/88e624332c10ec0b11e4758e16849edd.png)
6.拼凑日期、时间函数:makdedate(year,dayofyear), maketime(hour,minute,second)
SELECT MAKEDATE(2019,31) AS 'MAKEDATE';
![f55634005af6fcaecbbc0a6f04df1e3b.png](https://img-blog.csdnimg.cn/img_convert/f55634005af6fcaecbbc0a6f04df1e3b.png)
SELECT MAKETIME(23,15,30) AS '时间格式';
![453c831127be585ef7b5726231bede2a.png](https://img-blog.csdnimg.cn/img_convert/453c831127be585ef7b5726231bede2a.png)
7.(Unix 时间戳、日期)转换函数
unix_timestamp(),
unix_timestamp(date),
from_unixtime(unix_timestamp),
from_unixtime(unix_timestamp,format)
select unix_timestamp();
SELECT UNIX_TIMESTAMP('2019-07-03');
SELECT UNIX_TIMESTAMP('2019-07-03 23:14:00');
![b4bf58248c4cc8dafb2393be85e15a46.png](https://img-blog.csdnimg.cn/img_convert/b4bf58248c4cc8dafb2393be85e15a46.png)
![e9cca480a9bacde02efb971920d87e12.png](https://img-blog.csdnimg.cn/img_convert/e9cca480a9bacde02efb971920d87e12.png)
![e24430e4f1610e5ad9239154943e4067.png](https://img-blog.csdnimg.cn/img_convert/e24430e4f1610e5ad9239154943e4067.png)
8.时间间隔:date_add()
SET @datatime = NOW();
SELECT DATE_ADD(@datatime, INTERVAL 1 DAY);
SELECT DATE_ADD(@datatime, INTERVAL 1 HOUR);
SELECT DATE_ADD(@datatime, INTERVAL 1 MINUTE);
SELECT DATE_ADD(@datatime, INTERVAL 1 SECOND);
SELECT DATE_ADD(@datatime, INTERVAL 1 MICROSECOND);
SELECT DATE_ADD(@datatime, INTERVAL 1 WEEK);
SELECT DATE_ADD(@datatime, INTERVAL 1 MONTH);
SELECT DATE_ADD(@datatime, INTERVAL 1 QUARTER);
SELECT DATE_ADD(@datatime, INTERVAL 1 YEAR);
SELECT DATE_ADD(@datatime, INTERVAL -1 DAY) AS '时间';
![4f2cb395974c1497e493aae1dd8c3362.png](https://img-blog.csdnimg.cn/img_convert/4f2cb395974c1497e493aae1dd8c3362.png)
9.日期、时间相减函数:datediff(date1,date2), timediff(time1,time2)
SELECT DATEDIFF('2019-01-03', '2019-01-01') AS '相差多少天';
![2bd33d17c2568ec7cc3866034167c82b.png](https://img-blog.csdnimg.cn/img_convert/2bd33d17c2568ec7cc3866034167c82b.png)
10. 计算日期是星期几 DAYOFWEEK(date)
SELECT DAYOFWEEK('2019-07-03') AS '今天是星期几';
![f208b51004abab12adaea70a1ae91ddb.png](https://img-blog.csdnimg.cn/img_convert/f208b51004abab12adaea70a1ae91ddb.png)
11. 计算本月是第几天 DAYOFMONTH(date)
SELECT DAYOFMONTH('2019-07-02') AS '本月第几天';
![267c7c2bb27263da725c7f7f890dd5fb.png](https://img-blog.csdnimg.cn/img_convert/267c7c2bb27263da725c7f7f890dd5fb.png)
12. 计算本年是第几天DAYOFYEAR(date)
SELECT DAYOFYEAR('2019-07-02') AS '本年第几天';
![5ed471c093f37089af713887aca76b61.png](https://img-blog.csdnimg.cn/img_convert/5ed471c093f37089af713887aca76b61.png)
13. 计算本年是第几月份 MONTH(date)
SELECT MONTH('2019-07-02') AS '本年第几月份';
![78b3c05ad4f0422513ec99284a44e1a0.png](https://img-blog.csdnimg.cn/img_convert/78b3c05ad4f0422513ec99284a44e1a0.png)
14. 计算本年是第几季度 QUARTER(date)
SELECT QUARTER('2019-07-02') AS '本年第几季度';
![59dad6a820796f461f352fdf4c3caadf.png](https://img-blog.csdnimg.cn/img_convert/59dad6a820796f461f352fdf4c3caadf.png)