DATE_ADD function in BigQuery

The DATE_ADD function in BigQuery is used to add a specified time interval to a DATE value. The return data type of this function is also DATE.

SQL Syntax

DATE_ADD(date_expression, INTERVAL int64_expression date_part)    

Supported date_part Values

• DAY
• WEEK – Equivalent to 7 DAYS
• MONTH
• QUARTER
• YEAR

Example: Add 5 days to a given date.

SQL

SELECT DATE_ADD(DATE(2026, 01, 10), INTERVAL 5 DAY) AS five_days_later;    

The output of the above query is shown below: