ADD_MONTHS function fix

The output of the ADD_MONTHS function on a timestamp column was corrected to include the time.

Before Upgrade to CDP

The output of the following query incorrectly omitted the time:

select CUSTOMER_ID,EMAIL_FAILURE_DTMZ,ADD_MONTHS (EMAIL_FAILURE_DTMZ , 1) from TABLE1 where CUSTOMER_ID=125674937;

Example output:

1125674937   2015-12-09 12:25:53     2016-01-09

After Upgrade to CDP

Hive-19370 fixed the omission, so the output of the query above includes the time.

Example output:

125674937   2023-12-09 12:25:53           2024-01-09 12:25:53