ADDDATE

Syntax

Syntax 1

ADDDATE(date, INTERVAL expr unit)

Syntax 2

ADDDATE(expr, days)

Purpose

• The first declaration of this function is a synonym for DATE_ADD(), which adds a specified time interval to the date value date. For more information about the unit parameter, see DATE_ADD.
• The second declaration of this function adds days to the date specified by expr.

Examples

1. Enable the ClickHouse extension function mode.

   obclient> ALTER SYSTEM SET sql_func_extension_mode = "ClickHouse";
   

2. Add 3 days to the specified date.

   obclient> SELECT ADDDATE('2026-03-30', 3);
   

   The return result is as follows:

   +--------------------------+
   | ADDDATE('2026-03-30', 3) |
   +--------------------------+
   | 2026-04-02 00:00:00.000  |
   +--------------------------+
   1 row in set
   

3. Add 1 hour and 30 minutes to the specified date and time.

   obclient> SELECT ADDDATE('2026-03-30 10:00:00', INTERVAL 90 MINUTE);
   

   The return result is as follows:

   +----------------------------------------------------+
   | ADDDATE('2026-03-30 10:00:00', INTERVAL 90 MINUTE) |
   +----------------------------------------------------+
   | 2026-03-30 11:30:00.000                            |
   +----------------------------------------------------+
   1 row in set