Hi All,
I am trying to replace the value 00000000 with NULL and if the varchar(8) SAP HANA column contains correct values then load the date in YYYYMMDD format in SQL Server table. Source is SAP HANA
ifthenelse("Y.YM.YMCI.YMCIDN.YMCIDN01E02/ZNGDNETZ_NDH_117".ClearingDate='00000000',NULL,to_char("Y.YM.YMCI.YMCIDN.YMCIDN01E02/ZNGDNETZ_NDH_117".ClearingDate,'YYYYMMDD'))
I am getting the below error

Any inputs would be appreciated by points
Regards
Arun Sasi