Dremio Cloud
Dremio Software
 
On this page

    Categories: Date/Time

    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 or TIMESTAMP format, or literal value explicitly converted to DATE or TIMESTAMP).

    Examples

    TIMESTAMPADD example 
    SELECT timestampadd(day, 1, date '2021-04-01')
-- 2021-04-02
    TIMESTAMPADD example 
    SELECT timestampadd(hour, -2, timestamp '2021-04-01 17:14:32')
-- 2021-04-01 15:14:32