on 12-04-2018 6:10 AM
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
User | Count |
---|---|
4 | |
4 | |
3 | |
2 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.