Date And Time Functions

`DATEADD()`

Adds or subtracts datetime units from a datetime value

Result type

DATE, TIME or TIMESTAMP

Syntax

DATEADD (<args>)

<args> ::=
    <amount> <unit> TO <datetime>
  | <unit>, <amount>, <datetime>

<amount> ::= an integer expression (negative to subtract)
<unit> ::=
    YEAR | MONTH | WEEK | DAY
  | HOUR | MINUTE | SECOND | MILLISECOND
<datetime> ::= a DATE, TIME or TIMESTAMP expression

Table 1. `DATEADD` Function Parameters
Parameter	Description
amount	An integer expression of the `SMALLINT`, `INTEGER` or `BIGINT` type.For unit `MILLISECOND`, the type is `NUMERIC(18, 1)`.A negative value is subtracted.
unit	Date/time unit
datetime	An expression of the `DATE`, `TIME` or `TIMESTAMP` type

Adds the specified number of years, months, weeks, days, hours, minutes, seconds or milliseconds to a date/time value.

The result type is determined by the third argument.
With TIMESTAMP and DATE arguments, all units can be used.
With TIME arguments, only HOUR, MINUTE, SECOND and MILLISECOND can be used.

Date And Time Functions

Date and Time Functions

DATEADD()

`DATEADD()`