DATE_ADD

Computes a new TIMESTAMP or TIMESTAMPTZ value by adding or subtracting a specified number of time units from a DATE, TIMESTAMP, or TIMESTAMPTZ value. It’s similar to arithmetic with intervals, but it also allows using a column reference for the <quantity>.

Syntax

DATE_ADD('<unit>', <quantity>, <expression>)

Parameters

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> An expression evaluating to type DATE, TIMESTAMP, or TIMESTAMPTZ.

Return Types

TIMESTAMP if <expression> has type DATE or TIMESTAMP. TIMESTAMPTZ if <expression> has type TIMESTAMPTZ.

Example

SELECT date_add('week', 4, '2024-04-15 12:13:14'::timestamp);

Returns: '2024-05-13 12:13:14'::timestamp.