TIMESTAMPADD
Add (or subtract) an interval of time from a date/timestamp value or column.
Syntax
TIMESTAMPADD(unit symbol, count integer, givenTime date or timestamp) → date or timestamp
unit: The unit of the interval. Must be one of the following:
YEAR
,QUARTER
,MONTH
,WEEK
,DAY
,HOUR
,MINUTE
,SECOND
.count: Number of units to be added (or subtracted) from
givenTime
. To subtract units, pass a negative number.givenTime: Value to which to add units (either a database column in
DATE
orTIMESTAMP
format, or literal value explicitly converted toDATE
orTIMESTAMP
).
Examples
SELECT TIMESTAMPADD(DAY, 1, DATE '2021-04-01')
-- 2021-04-02
SELECT TIMESTAMPADD(HOUR, -2, TIMESTAMP '2021-04-01 17:14:32')
-- 2021-04-01 15:14:32
SELECT TIMESTAMPADD(MINUTE, -30, CURRENT_TIMESTAMP)
-- 2023-04-13 16:51:27.467
SELECT TIMESTAMPADD(SECOND, 3, CURRENT_TIMESTAMP)
-- 2023-04-13 17:24:15.446
Last updated
Was this helpful?