Skip to Content
0
Aug 04, 2016 at 10:43 AM

Replacing 00000000 with NULL

630 Views

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

Attachments