SELECT DATE_FORMAT('2019-08-08','%Y-%m-%d %H:%i:%s');
SELECT DATE_SUB( DATE_ADD('2019-08-08', INTERVAL 1 DAY),INTERVAL 1 SECOND)
SELECT DATE_FORMAT('2019-08-08','%Y-%m-%d %H:%i:%s');
SELECT DATE_SUB( DATE_ADD('2019-08-08', INTERVAL 1 DAY),INTERVAL 1 SECOND)