How to add a day in Vertica

In sql world we have “adddate()” function to add certain value on the given day. for instance I can say

select adddate('2016-2-28',2) as my_day;

and the out put will be ‘2016-03-01’

In Vertica world we don’t have adddate() function. We actually have ADD_MONTHS but not ADD_DAYS.

so my question is how are we going to add a day in Vertica

Answer

Vertica is clever enough to understand the following:

SQL> select '2016-02-28'::date + 2 ;

Leave a Reply

Your email address will not be published. Required fields are marked *