从字符串转换日期和/或时间时转换失败.mule 4大容量插入SQL Server时出错

Question

有效载荷是json格式的字符串，如下所示。日期给了我上述错误。为什么Created_Date中所需的varchar格式正确？插入查询是

INSERT INTO SAPHDS_Inbound_Landing_Table(
Builder,Created_Date,Builder_Name,Builder_Abbrev,
Street_Address,City,State,Postal_code,Builder_Acct_Group,
Status,Record_Change_Date) 
values (:Builder,:Created_Date,:Builder_Name,:Builder_Abbrev,
:Street_Address,:City,:State,:Postal_Code,:Builder_Acct_Group,
:Status,:Record_Change_Date); 

output application/json
---
payload map {
'Builder': $.BUILDER default "",
'Builder_Abbrev': $.BUILDER_ABBREV_CODE default "",
'Builder_Acct_Group': $.BUILDER_AGROUP default "",
'Builder_Name': $.BUILDER_NAME default "",
'City': $.BUILDER_CITY default "",
'Created_Date': (now() >> "US/Arizona") as String{format:"yyyy-MM-dd HH:mm:ss.SSS"} ,
'Postal_Code': $.BUILDER_PCODE default "",
'Record_Change_Date': $.CHANGE_DATE ,
'State': $.BUILDER_STATE default "",
'Status': $.BUILDER_STATUS default "",
'Street_Address': $.BUILDER_STREET default "",
'Integration_Status':'P',
'SAP_API_Function': p('builder.sapAPIFunction')
}

Answer 1

尝试将DB中的Created_Date字段更改为nvarchar或datetime，看看是否有帮助。