/* 035- Date Functions - II */
SELECT ADDDATE("2019-06-15",INTERVAL 10 DAY) AS Date;
SELECT ADDDATE("2019-06-15",INTERVAL 50 DAY) AS Date;
SELECT ADDDATE("2019-06-15",INTERVAL 1 MONTH) AS Date;
SELECT ADDDATE("2019-06-15",INTERVAL 1 WEEK) AS Date;
SELECT ADDDATE("2019-06-15",INTERVAL 1 YEAR) AS Date;
SELECT ADDDATE("2019-06-15",INTERVAL 1 QUARTER) AS Date;
SELECT ADDDATE("2019-06-15",INTERVAL 12 HOUR) AS Date;
SELECT ADDDATE("2019-06-15",INTERVAL 24 HOUR) AS Date;
SELECT ADDDATE("2019-06-15",INTERVAL 500 MINUTE) AS Date;
SELECT ADDDATE("2019-06-15",INTERVAL 5000 MINUTE) AS Date;
SELECT DATE_ADD("2019-06-15",INTERVAL 5000 MINUTE) AS Date;
SELECT MAKEDATE(2019,3);
SELECT MAKEDATE(2016,3);
SELECT SUBDATE("2019-06-15",INTERVAL 1 DAY) AS Date;
SELECT SUBDATE("2019-06-15",INTERVAL 10 DAY) AS Date;
SELECT SUBDATE("2019-06-15",INTERVAL 10 MONTH) AS Date;
SELECT DATEDIFF("2019-06-15","2019-02-10") AS Date;
SELECT DATEDIFF("2019-06-15","2019-06-01") AS Date;
SELECT DATEDIFF("2019-06-15","2018-06-01") AS Date;
SELECT TO_DAYS("2019-06-15") AS Date;
SELECT FROM_DAYS("685000") AS Date;
SELECT PERIOD_ADD("685000",5) AS Date;
SELECT PERIOD_DIFF("685000","695000") AS Date;
SELECT DATE_FORMAT("2019-06-15","%Y") AS Date;
SELECT DATE_FORMAT("2019-06-15","%d/%b/%Y") AS Date;
SELECT DATE_FORMAT("2019-06-15","%d-%c-%Y") AS Date;
SELECT DATE_FORMAT("2019-06-15","%d/%b/%y") AS Date;
SELECT DATE_FORMAT("2019-06-15","%d-%c-%y, %W") AS Date;
SELECT DATE_FORMAT("2019-06-15 02:30:50:20","%d-%c-%y, %h:%i") AS Date;
SELECT STR_TO_DATE("July 10 2019","%M %d %Y") AS Date;