I want to calculate start and end week of a particular date where week start date is Monday and end is Sunday
I’ve tried using ADD_DAYS & DATEADD which is in supported vertica sql functions but getting error that it requires permission
Solved
How to add days to a date column in vertica sql?
Best answer by guillermo.gost12
+26Hi @Preethi P,
Strange that ADD_DAYS & DATEADD don't work, since they should be supported (see Supported Vertica functions (celonis.com)). Also, the ADD_MONTHS works, which is in the same area.
If this error persists, you could create a support ticket to Celonis.
@Guillermo Gost Thank you
TIMESTAMPADD worked
Hi @Preethi P,
Strange that ADD_DAYS & DATEADD don't work, since they should be supported (see Supported Vertica functions (celonis.com)). Also, the ADD_MONTHS works, which is in the same area.
If this error persists, you could create a support ticket to Celonis.
@janpeter.van.d yes, I’ve checked as they listed as supported functions.
Yes, I created a support ticket
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.