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
Vertica is clever enough to understand the following:
SQL> select '2016-02-28'::date + 2 ;