Skip to main content
Solved

How to add days to a date column in vertica sql?

  • Jan 25, 2023 2:54 PM UTC
  • 4 replies
  • 238 views

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

Best answer by Anonymous

Try TIMESTAMPADD

 

https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Date-Time/TIMESTAMPADD.htm

 

 

View original

4 replies

  • Answer
  • Jan 25, 2023 3:09 PM UTC

Jan-Peter van der Steege
Community MVP
Forum|alt.badge.img+28

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.

 


  • Jan 27, 2023 5:33 PM UTC

  • Jan 27, 2023 5:34 PM UTC

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