Reference material for DATE_ADD function
<quantity>
.
Parameter | Description |
---|---|
<unit> | A TEXT literal specifying the time unit. Must be one of microsecond ,millisecond ,second ,minute ,hour ,day ,week ,month ,quarter ,year ,decade ,century , or millennium . |
<quantity> | An INT or BIGINT specifying how often the time unit should be added or subtracted to <expression> . |
<expression> | An expression evaluating to type DATE, TIMESTAMP, or TIMESTAMPTZ. |
<expression>
has type DATE or TIMESTAMP.
TIMESTAMPTZ if <expression>
has type TIMESTAMPTZ.