注册

MySQL迁移至达梦报错:java.sql.SQLException: HOUR_OF_DAY: 0 -> 1

Mr.Bean 2025/01/14 403 3

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】: dm8
【操作系统】:麒麟10
【CPU】: 海光
【问题描述】*:MySQL迁移至达梦时报错:java.sql.SQLException: HOUR_OF_DAY: 0 -> 1,部分数据迁移成功。
表结构
CREATE TABLE "UFWP_SHANGRAO"."E_INV_PERSON"
(
"INVID" VARCHAR(200) NOT NULL,
"PRIPID" VARCHAR(72),
"INV" VARCHAR(200),
"CERTYPE" VARCHAR(128),
"CERTYPE_CN" VARCHAR(256),
"CERNO" VARCHAR(100),
"LISUBCONAM" DECIMAL(18,6),
"SUBCONAMUSD" DECIMAL(18,6),
"SUBCONFORM" VARCHAR(400),
"SUBCONPROP" DECIMAL(16,4),
"CONDATE" TIMESTAMP(0),
"ACCONAMUSD" DECIMAL(18,6),
"DOM" TEXT,
"CURRENCY" VARCHAR(128),
"CURRENCY_CN" VARCHAR(256),
"COUNTRY" VARCHAR(256),
"COUNTRY_CN" VARCHAR(256),
"EXEAFFSIGN" VARCHAR(128),
"RESPFORM" VARCHAR(128),
"RESPFORM_CN" VARCHAR(256),
"SCONFORM" VARCHAR(400),
"SEX" VARCHAR(128),
"NATION" VARCHAR(128),
"NATDATE" TIMESTAMP(0),
"LITDEG" VARCHAR(128),
"POLSTAND" VARCHAR(128),
"OCCST" VARCHAR(256),
"POSTALCODE" VARCHAR(12),
"TEL" VARCHAR(60),
"S_EXT_FROMNODE" VARCHAR(12),
"S_EXT_DATATIME" TIMESTAMP(0),
"LIACCONAM" DECIMAL(18,6),
"ZX_ID" TEXT,

回答 0
暂无回答
扫一扫
联系客服