一. NOW()
NOW():当前日期和时间
mysql> SELECT NOW(); +---------------------+ | NOW() | +---------------------+ | 2018-03-01 12:39:19 | +---------------------+ 1 row in set (0.00 sec)
二. CURDATE()
CURDATE():当前日期
mysql> SElECT CURDATE(); +------------+ | CURDATE() | +------------+ | 2018-03-01 | +------------+ 1 row in set (0.00 sec)
三. CURTIME()
CURTIME():当前时间
mysql> SElECT CURTIME(); +-----------+ | CURTIME() | +-----------+ | 12:40:37 | +-----------+ 1 row in set (0.00 sec)
四. DATE_ADD()
DATE_ADD():日期变化
mysql> SELECT DATE_ADD('2018-3-1',INTERVAL 365 DAY); +---------------------------------------+ | DATE_ADD('2018-3-1',INTERVAL 365 DAY) | +---------------------------------------+ | 2019-03-01 | +---------------------------------------+ 1 row in set (0.00 sec) mysql> SELECT DATE_ADD('2018-3-1',INTERVAL -365 DAY); +----------------------------------------+ | DATE_ADD('2018-3-1',INTERVAL -365 DAY) | +----------------------------------------+ | 2017-03-01 | +----------------------------------------+ 1 row in set (0.00 sec) mysql> SELECT DATE_ADD('2018-3-1',INTERVAL 1 YEAR); +--------------------------------------+ | DATE_ADD('2018-3-1',INTERVAL 1 YEAR) | +--------------------------------------+ | 2019-03-01 | +--------------------------------------+ 1 row in set (0.00 sec) mysql> SELECT DATE_ADD('2018-3-1',INTERVAL 3 month); +---------------------------------------+ | DATE_ADD('2018-3-1',INTERVAL 3 month) | +---------------------------------------+ | 2018-06-01 | +---------------------------------------+ 1 row in set (0.00 sec) mysql> SELECT DATE_ADD('2018-3-1',INTERVAL 3 WEEK); +--------------------------------------+ | DATE_ADD('2018-3-1',INTERVAL 3 week) | +--------------------------------------+ | 2018-03-22 | +--------------------------------------+ 1 row in set (0.00 sec)
五. DATEDIFF()
DATEDIFF():日期差值
mysql> SELECT DATEDIFF('2019-3-1','2018-6-3'); +---------------------------------+ | DATEDIFF('2019-3-1','2018-6-3') | +---------------------------------+ | 271 | +---------------------------------+ 1 row in set (0.00 sec)
六. DATE_FORMAT()
DATE_FORMAT():日期格式化
mysql> SELECT DATE_FORMAT('2018-3-1','%m / %d / %Y '); +-----------------------------------------+ | DATE_FORMAT('2018-3-1','%m / %d / %Y ') | +-----------------------------------------+ | 03 / 01 / 2018 | +-----------------------------------------+ 1 row in set (0.00 sec)
请登录之后再进行评论