I have this requirement: There is a field of 8-byte length and I want to extract the last 4 bytes using SQL.
Example: There is date 01012017 so I want only 2017. How can I achieve this using WHERE clause.
Asked
Active
Viewed 1,882 times
0
Sandra Rossi
- 11,934
- 5
- 22
- 48
Ankit Setia
- 1
- 1
-
What tables? What fields? – Nelson Miranda Jul 29 '18 at 15:04
-
1use `WHERE date = lv_date+4(4)` – Suncatcher Jul 29 '18 at 15:07
-
1Possible duplicate of [How do I use substring in OpenSQL ABAP WHERE clause?](https://stackoverflow.com/questions/47885655/how-do-i-use-substring-in-opensql-abap-where-clause) – Gert Beukema Jul 29 '18 at 18:05
-
What's wrong with the LIKE clause? – VXLozano Jul 30 '18 at 07:36
1 Answers
0
You should select the data in full flesh, then use
LOOP AS it_fulldate ASSIGNING <ls_fulldate>.
<ls_fulldate>-date = <ls_fulldate>-date+4(4).
ENDLOOP.
But usually, date time data type is YYYYMMDD so the correct might be <ls_fulldate>-date+0(4)
Binh
- 241
- 1
- 15