Subtraction of date columns

573 Views Last edit Feb 14, 2017 at 07:08 AM 2 rev

Hi Team,

I am trying to run below query in HANA SQL analyzer but getting error as "TIMESTAMP is invalid for subtraction operator". Can someone have a look and help in this regard.

SELECT MAX(LST_MODF_TS) MAX_LST_DT, ADD_SECONDS (TO_TIMESTAMP(CURRENT_TIMESTAMP), -(120*60) ) MINUS_2_HOURS, MAX(LST_MODF_TS) - ADD_SECONDS (TO_TIMESTAMP(CURRENT_TIMESTAMP), -(120*60) ) FROM ZSFC_SD.ACTIVITY_TABLE;

Thanks,

Abdulrasheed.