Search code examples
javavertica

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

Solution

  • Vertica is clever enough to understand the following:

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