Impala Add months to current time

Question

Hi. I am using Impala to get the current time and then to set an expiry timestamp. I am getting the current time using the select now() query. The expiry should be after two months. So how can I add two months to the current time?

Answer 1

You can add the months using the add_months method as follows:

select now(), add_months(now(), 2);
+-------------------------------+-------------------------------+
| now()                         | add_months(now(), 2)          |
+-------------------------------+-------------------------------+
| 2016-05-31 10:47:00.429109000 | 2016-07-31 10:47:00.429109000 |
+-------------------------------+-------------------------------+