A character string failed conversion to a numeric value: Teradata insert

4.2k views Asked by At

I am trying to execute the insert statement in teradata and getting the error message 'A character string failed conversion to a numeric value'

INSERT INTO USS_LOAD.RX_CLAIM (RX_CLAIM_PRCSR_PRTY_ID,RX_CLAIM_PRCSR_ORGN_NM, 
RX_CLAIM_PRCSR_PRTY_STRT_DT, RX_CLAIM_PRCSR_PRTY_END_DT,DW_UPDT_DTTM, DW_UPDT_USR)
VALUES (-104,'MeridianRx','1/23/2020','12/31/9999',current_timestamp(6),user);

The structure is as below

RX_CLAIM_PRCSR_PRTY_ID (BIGINT,NOT NULL),
RX_CLAIM_PRCSR_ORGN_NM (VARCHAR(100)),
RX_CLAIM_PRCSR_PRTY_STRT_DT (DATE),
RX_CLAIM_PRCSR_PRTY_END_DT (DATE),
DW_UPDT_DTTM (TIMESTAMP(6), 
DW_UPDT_USR (VARCHAR(72)
0

There are 0 answers