Skip to main content

TIMESTAMPADD function

Adds the specified interval to a timestamp.

Syntax

TIMESTAMPADD(datepart, count, start)

Arguments

  • datepart: one of YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE, SECOND, MILLISECOND, or MICROSECOND.

  • count: a BIGINT.

  • start: a TIMESTAMP or TIMESTAMP_TZ.

Returns

A TIMESTAMP or TIMESTAMP_TZ.

Examples

> SELECT TIMESTAMPADD(HOUR, 2, TIMESTAMP '2001-02-03 04:00:00');
 2001-02-03 06:00:00
> SELECT TIMESTAMPADD(HOUR, 2, TIMESTAMP WITH TIME ZONE '2001-02-03 04:00:00 EST');
 2001-02-03 11:00:00