MySQLの日付関数の使用例

SELECT CURDATE();
SELECT CURRENT_DATE();
---- 返回2019-02-19

SELECT CURRENT_TIME();
---- 返回11:40:45

SELECT CURRENT_TIMESTAMP();
---- 返回2019-02-19 11:41:32

SELECT ADDDATE("2017-06-15", INTERVAL 10 DAY);
---- 返回2017-06-25

SELECT ADDTIME('2011-11-11 11:11:11', 5);
---- 返回2011-11-11 11:11:16

SELECT DATE("2017-06-15 11:11:16");
---- 返回2017-06-15

SELECT DAY("2017-06-15"); 
---- 返回15

SELECT DATEDIFF('2001-01-01','2001-02-02'); 
---- 返回-32

SELECT DATE_FORMAT('2011.11.11 11:11:11','%Y-%m-%d %r');
---- 返回2011-11-11 11:11:11 AM

SELECT DAYNAME('2011-11-11 11:11:11');
---- 返回Friday

SELECT DAYOFMONTH('2011-11-11 11:11:11');
---- 返回11

SELECT DAYOFYEAR('2011-11-11 11:11:11');
---- 返回315

SELECT EXTRACT(MINUTE FROM '2011-12-13 14:15:16');
---- 返回15

SELECT UNIX_TIMESTAMP('2019-2-19');
SELECT UNIX_TIMESTAMP(expression);
---- 返回1550505600