amazon-redshiftHow do I use the Amazon Redshift Dateadd function?

The DATEADD function in Amazon Redshift is used to add or subtract a specified time interval from a given date. It takes three parameters: an interval type, a number, and a date.

SELECT DATEADD(day, 10, '2018-12-25');

Output example

2018-01-04

This example adds 10 days to the date 2018-12-25 and returns the result 2018-01-04.

The interval type is one of the following: year, quarter, month, day, hour, minute, second, millisecond.

The number is the number of interval types to add or subtract.

The date is the date to which the interval is added or subtracted.

Helpful links

• Amazon Redshift Documentation - DATEADD
• PostgreSQL Documentation - DATEADD

Edit this code on GitHub