The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Add or subtract days to timestamp
We need to get 1-day, 7-day and 30-day averages, so we need to calculate the time stamp of 1, 7 or 30 days prior to a given timestamp. There is a function ADD_MONTHS, so I was looking for something like ADD_DAYS but did not find it. What function can be used for this purpose?