DATEADD

    Syntax

    DATEADD( datetime [ , unit [ , number ] ] )
    

    Description

    Returns the date obtained by adding unit in the amount of number to the specified date datetime.

    The number argument is an integer. It can be negative.
    The unit argument takes the following values:

    • "year";
    • "month";
    • "day";
    • "hour";
    • "minute";
    • "second".

    Argument types:

    • datetimeDate | Datetime
    • unitInteger | String
    • numberInteger

    Return type: Same type as (datetime)

    Note

    Only constant values are accepted for the arguments (unit).

    Note

    For all sources except ClickHouse, number takes only constant values.

    Examples

    DATEADD(#2018-01-12#, "day", 6) = #2018-01-18#
    
    DATEADD(#2018-01-12#, "month", 6) = #2018-07-12#
    
    DATEADD(#2018-01-12#, "year", 6) = #2024-01-12#
    
    DATEADD(#2018-01-12 01:02:03#, "second", 6) = #2018-01-12 01:02:09#
    
    DATEADD(#2018-01-12 01:02:03#, "minute", 6) = #2018-01-12 01:08:03#
    
    DATEADD(#2018-01-12 01:02:03#, "hour", 6) = #2018-01-12 07:02:03#
    
    DATEADD(#2018-01-12 01:02:03#, "day", 6) = #2018-01-18 01:02:03#
    
    DATEADD(#2018-01-12 01:02:03#, "month", 6) = #2018-07-12 01:02:03#
    
    DATEADD(#2018-01-12 01:02:03#, "year", 6) = #2024-01-12 01:02:03#
    

    Data source support

    ClickHouse 19.13, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.