How to subtract month from Impala time stamp

Question

In Impala, I used the select now() query to get the current timestamp and add_months(now(), 2) to add months to the timestamp. My question is, how can I subtract the month from the timestamp? I could not find any subtract_months() method. Please help.

Answer 1

You don't need another method, you can use the add_months method with a negative value to subtract month. You can try something like this:

select now(), add_months(now(), -1);