below query gives 2 different wrong length same numbers ,in ibm db2 sql why there 2 different length same value ?
select decimal(trim(cast(15 char(2)))||trim(lpad(cast(7 char(2)),2,'0'))||trim(lpad(cast(13 char(2)),2,'0'))), length(decimal(trim(cast(15 char(2)))||trim(lpad(cast(7 char(2)),2,'0'))||trim(lpad(cast(13 char(2)),2,'0')))), decimal(trim(substr(replace(char(current_date -1 days,iso),'-',''),3,6)),6,0), length(decimal(trim(substr(replace(char(current_date -1 days,iso),'-',''),3,6)),6,0)) sysibm.sysdummy1
these numbers not same value first 1 15713 , second 150713.
Comments
Post a Comment