Skip to Content
0
Jun 23, 2020 at 07:37 AM

How to do Date Conversion from field GDATU in TCURR in sap hana studio?

4376 Views

Hi Everyone,

I tried to convert the date from the table TCURR.GDATU, I tried with various ways it's not working

System details : SAP HANA 1.0 SP 12

select (99999999- cast("GDATU" as Integer)) as "CasT" from SCHEMA.TCURR

error:[6930] attribute value is not a number;int sqlsub(int '99999999', int [here]int(string "GDATU")),GDATU = ''[string]; checkNull false

select KURST,FCURR,TCURR, CAST(LEFT(99999999-GDATU,4)*10000+RIGHT(LEFT(99999999-GDATU,6),2)*100+RIGHT(99999999-GDATU,2) AS DATE) AS START_DATE from SCHEMA.TCURR

Error : "Could not execute 'select KURST,FCURR,TCURR, ...' in 61 ms 768 µs . SAP DBTech JDBC: [339]: invalid number: [6930] attribute value is not a number;daydate comma(string string(int sqlsub(int '99999999', int [here]int(string "GDATU"))), daydate daydate(int sqladd(int sqladd(int times(int int(string midstru(string "__common1", int '1', int '4')), int '10000'), int times(int int(string rightstru(string midstru(string "__common1", int '1', int '6'), int '2')), int '100')), int int(string rightstru(string "__common1", int '2'))))),GDATU = ''[string]; checkNull false"

Kindly let me know how to convert the date from TCURR.GDATU ?

Thank you!