DATE_ADD

All functions > DATE AND TIME > DATE_ADD

Returns the date/timestamp after adding a given number of a given units to the given date/timestamp.

Signatures

Returns: A new timestamp with the interval added

DATE_ADD(timestamp: TIMESTAMP, unit: VARCHAR, value: BIGINT) → TIMESTAMP

Notes

• Adds a specified interval to a timestamp
• Common units: 'second', 'minute', 'hour', 'day', 'week', 'month', 'year'
• Value can be positive (future) or negative (past)
• Useful for date arithmetic and scheduling
• Handles month/year boundaries correctly

Examples

SELECT
    f1 := DATE_ADD(TIMESTAMP '2024-03-15 10:00:00', 'day', 7),  -- Add 7 days
    f2 := DATE_ADD(TIMESTAMP '2024-03-15 10:00:00', 'hour', 3),  -- Add 3 hours
    f3 := DATE_ADD(TIMESTAMP '2024-03-15 10:00:00', 'month', -1)  -- Subtract 1 month
;