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 or timestamp.

Signatures

Returns: A new timestamp with the interval added

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

Notes

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

Examples

Date inputs

SELECT
    f1 := DATE_ADD(DATE '2024-03-15', 'day', 7), -- Add 7 days to a date
    f2 := DATE_ADD(DATE '2024-03-15', 'month', 2) -- Add 2 months to a date
;

Timestamp inputs

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
;