datetime-queries.sql

-- '2019-05-25 13:00:10.123456'  -- DATETIME
-- '2018-05-26 11:00:10.133333'
-- '2019-04-01'  -- DATE
-- '2019-02-03'  
-- '09:20:00.123456' -- TIME
-- '15:20:00.123456'
-- 1559335502  -- TIMESTAMP

 SELECT UNIX_TIMESTAMP('2019-05-25 13:00:10.123456'), UNIX_TIMESTAMP(), NOW(), SYSDATE(6);

 SELECT ADDDATE('2019-04-01', INTERVAL 3 DAY);  -- ADDTIME()
 SELECT SUBDATE('2019-04-01', INTERVAL 3 DAY);  -- SUBTIME()
 SELECT DATEDIFF('2019-04-01', '2019-02-03'), DATEDIFF('2019-02-03', '2019-04-01'); -- TIMEDIFF()

 SELECT TIMESTAMPDIFF(MONTH, '2019-04-01', '2019-02-01'), TIMESTAMPDIFF(MINUTE, '2019-05-25 13:00:10.123456', '2018-05-26 11:00:10.133333');

 SELECT MAKETIME(14, 22, 1);

 SELECT LAST_DAY('2019-02-03');

 SELECT GET_FORMAT(DATETIME, 'USA'), GET_FORMAT(DATETIME, 'EUR'), GET_FORMAT(DATETIME, 'ISO');
      
 SELECT DATE_FORMAT('2019-05-25 13:00:10.123456', '%Y-%m-%d %H:%i:%s');