java - SQL Server 将 nvarchar 值 '2018-10-03' 转换为数据类型 int 时出现异常失败

Question

在java中执行SQL查询时出现错误“SQL Server 异常:com.microsoft.sqlserver.jdbc.SQLServerException:将 nvarchar 值“2018-10-03”转换为数据类型 int 时转换失败”

SQL查询

String MemberId = “103113213”;
String StartDate = ”2019-05-20”;

    select distinct BLRC_CREATE_DTM,BLRC_AMT
    FROM CMC_BLRC_BILL_RCPT D,CMC_SBSB_SUBSC A,CMC_GRGR_GROUP C,CDS_INID_INVOICE B
WHERE A.GRGR_CK = C.GRGR_CK
AND A.SBSB_CK = B.SBSB_CK
AND B.BLEI_CK = D.BLEI_CK
AND A.SBSB_ID IN ('"+MemberId+"')
AND FORMAT(BLRC_CREATE_DTM, 'yyyy-MM-dd') ="+StartDate+"";

Answer 1

String MemberId = “103113213”;
String StartDate = ”2019-05-20”;

    select distinct BLRC_CREATE_DTM,BLRC_AMT
    FROM CMC_BLRC_BILL_RCPT D,CMC_SBSB_SUBSC A,CMC_GRGR_GROUP C,CDS_INID_INVOICE B
WHERE A.GRGR_CK = C.GRGR_CK
AND A.SBSB_CK = B.SBSB_CK
AND B.BLEI_CK = D.BLEI_CK
AND A.SBSB_ID IN ('"+MemberId+"')
AND FORMAT(BLRC_CREATE_DTM, 'yyyy-MM-dd') = CONVERT(date, StartDate);

请确保您仅提供输入日期和保存日期。