Yes, that’s right.
However, apart from the ones we discussed a while ago, Vertica and MySQL also offer a few more ways on which you can fall back if you’d like to have simpler syntax.
|Vertica||add_months(timestamp, unit)||adds months to a date|
|MySQL||adddate(timestamp, unit)||adds days to a date|
|MySQL||addtime(timestamp, unit)||adds seconds to a date|
|MySQL||subdate(timestamp, unit)||subtracts days from a date|
|MySQL||subtime(timestamp, unit)||subtracts seconds from a date|
|MySQL||period_add(yyyymm, unit)||adds months to a year-month period*|
*super handy if used with dynamic year-month periods and you can easily get those by using the concat() function