DateAdd Equivalent

[stwp86]

Does anyone know, off of the top of their head, if there is a Dateadd equivalent available in Vertica SQL? In MSSQL you feed in the following:

DATEADD(datepart, number, date)

I want to do something like this:

To_Char(Timestamp_Trunc(wo.Start_Date, 'DAY')+1, 'MM/DD/YYYY') >= Dateadd(, -4, ?)

The ? is a parameter that will give the ending date (via report builder report), so basically it is looking at the last four weeks worth of data.

Thanks for the help!

Travis

[jpcavanaugh]

I would start here.

http://my.vertica.com/docs/6.0.1/HTML/i ... m#8658.htm

[stwp86]

Thanks, I found it earlier in some documentation . . . it is Timestampadd