Oracle SQL 插入数据报错 ORA-01861: literal does not match format string 解决方法

{"title":"Oracle SQL 插入数据报错 ORA-01861: literal does not match format string 解决方法","description":"本文介绍了Oracle数据库中插入数据时遇到的错误“ORA-01861: literal does not match format string”的解决方法，并提供了示例代码。","keywords":"Oracle, SQL, 插入数据, 错误, ORA-01861, 日期格式, TO_DATE","content":"INSERT INTO TBL_CUSTWS_FLEXGS_LABEL\n(\nFACTORYNO ,CUSTNO ,MKDATE ,ISLAST ,PRODID\n,CUSTPRODID ,CUSTFACTPRODID ,PRODNAME ,PRODTYPE\n,OUTBOX ,INBOX ,OUTCOUNT ,INCOUNT\n,OUTPRINTY ,INPRINTY ,CREATEUSER ,CREATEDATE\n,DATECODE ,MKNO ,PO \n,GROSSWEIGHT ,NETWEIGHT ,STATUS\n,ENVLEVEL,TOTALBOXCOUNT,STARTBOX,ENDBOX,CURRENTBOX,TOTALPOQTY,PSNUMBER\n,DELIVERYADD,SHIPPINGFROM,CUSTCOMPANYNO,CUSTCOMPANYNAME,CUSTFACTORYNO,CUSTFACTORYNAME,VERSION\n)\nVALUES\n(\n'BT' ,'0000600344' ,TO_DATE('2023/07/27 11:33:22', 'YYYY/MM/DD HH24:MI:SS') ,'0' ,'ABAT0050-P001A'\n,'LIFH-31-243-07' ,'MAP-ABAT0050-P001A' ,'Lite-Trap Teminal' ,'WN'\n,'6000' ,'1000' ,'1' ,'6'\n,'0' ,'0' ,'admin' ,SYSDATE\n,'2330' ,'SAP20230101' ,'PO20230101' \n,'12.3' ,'11.80' ,'N'\n,'HF','1','1','1','1','0','PSNUM2023'\n,'Flextronics Manufacturing (H.K.) Ltd. \nUnit 2,10th floor,Goodman Global Gateway,168 Yeung UK Road,Tsuen Wan,N.T. HONG KONG\nATT:Rita Wan TEL:+86 755 8947 6153','LOTES GUANGZHOU CO., LTD\nNO.526, NORTH OF JINLING ROAD, \nNANSHAECONOMIC&\nTECHNOLOGICAL\nDEVELOPMENT ZONE,\nGUANGZHOU 511458 CHINA.','0000600344','Flex(Gushu)','','','V1'\n) RETURN ID INTO :wID"}