I want to add days to a date in vertica SQL in transformations.I have tried using DATEADD and TIMESTAMPADD, both are showing permission denied.Please help how can i achieve this.

Hi,

TIMESTAMPADD works fine for me. Probably you messed up the syntax.

Adding a screenshots of something 'not working' usually make easier to help.

Code:

SELECT TIMESTAMPADD (DD, 2, (SELECT TRUNC((CURRENT_TIMESTAMP), 'MM'))),

 TRUNC((CURRENT_TIMESTAMP), 'MM') AS Initial_timestam ;

Documentation: TIMESTAMPADD (vertica.com)

Screenshot:

Mark as best answer if helped, and let us know if that worked :)

Best Regards,

Mateusz Dudek

Hello, U can try something like this, this will work.

To add days: TIMESTAMPADD('day',1,GETDATE())

To minus days: TIMESTAMPADD('day',-1,GETDATE())

Hi @chaithanya.reddy11 ,

If you're getting TIMESTAMPADD is not supported while running the syntax in transformation. Please raise a feature request. Valid Engineer will add TIMESTAMPADD in your environment.