cancel
Showing results for 
Search instead for 
Did you mean: 

TIMESTAMP is invalid for subtraction operator

Former Member
0 Kudos

HI, Below is the query I am using for one of the reports.

Post HANA migration, I have started getting the below error.

Can someone please help me with this?

and (e.lst_upd_tstmp > ((CURRENT_TIMESTAMP -1/96) - 1/1440*2) and e.lst_upd_tstmp <= (CURRENT_TIMESTAMP - 1/1440*2))

Here, I am trying to get the time interval of -17min to -2min from the current date and 'e' is alias for one of the tables I am using.

The error occurred is -

nconsistent datatype: the expression has incomputable datatype: TIMESTAMP.

TIMESTAMP is invalid for subtraction operator

Accepted Solutions (0)

Answers (0)