Date Functions – Date Add, Date Sub, Last Day

/*
  Last Day
  LAST_DAY(Date)
*/

SELECT name, date, LAST_DAY(date) FROM `try`;

SELECT name, date, LAST_DAY(date), DAYNAME(LAST_DAY(date)) FROM `try`;

/*
  Date Add
  DATE_ADD(Date, Interval Expression Time Unit)
*/

UPDATE `try` SET date = DATE_ADD(date, INTERVAL 10 DAY);

UPDATE `try` SET date = DATE_ADD(date, INTERVAL 1 MONTH);

/*
  Date Sub
  DATE_SUB(Date, Interval Expression Time Unit)
*/

UPDATE `try` SET date = DATE_SUB(date, INTERVAL 1 MONTH);