Syntax\n------\n\nDATE_ADD(date,INTERVAL expr unit)\n\nDescription\n-----------\n\nPerforms date arithmetic. The _date_ argument specifies the starting date or datetime value. _expr_ is an expression specifying the interval value to be added to the starting date. _expr_ is a string; it may start with a "-" for negative intervals. For composite interval units (such as DAY_HOUR, MINUTE_SECOND, and SECOND_MICROSECOND), \n_expr_ can contain multiple components separated by spaces or punctuation. For example:\n\n- '1 10' DAY_HOUR represents 1 day and 10 hours  \n- '1:1' MINUTE_SECOND represents 1 minute and 1 second  \n- '1.999999' SECOND_MICROSECOND represents seconds and microseconds  \n\nThe exact format of _expr_ depends on the _unit_ specified.\n\n_unit_ is a keyword indicating the units in which the expression should be interpreted. See Date and Time Units for a complete list of permitted units.\n\nThe result type of DATE_ADD() is determined as follows:\n\n if the first argument is of the type DATETIME, the function returns DATETIME ;\n if the first argument is DATE and the interval uses HOUR or smaller units, the function returns DATETIME ;\n if the first argument is DATE and the interval uses DAY or larger units, the function returns DATE ;\n similarly, if the first argument is TIME and the interval uses DAY or smaller units the function returns TIME, if the interval uses anything larger, the function returns DATETIME ;\n* if the first argument isn't a temporal type, the function returns a string.\n\nExamples\n--------\n\nSELECT '2008-12-31 23:59:59' + INTERVAL 1 SECOND;\n+-------------------------------------------+\n| '2008-12-31 23:59:59' + INTERVAL 1 SECOND |\n+-------------------------------------------+\n| 2009-01-01 00:00:00                       |\n+-------------------------------------------+\n\nURL: https://mariadb.com/docs/server/reference/sql-functions/date-time-functions/date_add