date_add

Adds an interval to a DateTime value.

date_add(date, expr, unit)

The date argument indicates the starting DateTime or Timestamp value. Expr is a string specifying the interval value to be added, it may start with a '-' for negative values. Unit is a string specifying the expression's unit.

Unit Expr Format
SECOND SECONDS
MINUTE MINUTES
HOUR HOURS
DAY DAYS
WEEK WEEKS
MONTH MONTHS
YEAR YEARS
MINUTE_SECOND MINUTES:SECONDS
HOUR_SECOND HOURS:MINUTES:SECONDS
HOUR_MINUTE HOURS:MINUTES
DAY_SECOND DAYS HOURS:MINUTES:SECONDS
DAY_MINUTE DAYS HOURS:MINUTES
DAY_HOUR DAYS HOURS
YEAR_MONTH YEARS-MONTHS

SELECT DATE_ADD('1447671624', '1', 'SECOND') -> '2015-11-16 11:00:25'