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!