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)