注册

字符串转换出错

瑾梦 2024/12/04 553 13 已解决

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
建表语句:CREATE TABLE "test"."MMT"
(
"ID" BIGINT IDENTITY(163, 1) NOT NULL,
"CITY_CODE" INT,
"ORG_ID" BIGINT,
"ORG_NAME" VARCHAR(120),
"ORG_SHOW_NAME" VARCHAR(64),
"GZ_STU_SUM" VARCHAR(50) DEFAULT '0',
"OFFLINE_STU_SUM" VARCHAR(50) DEFAULT '0',
"ONLINE_STU_SUM" VARCHAR(50) DEFAULT '0',
"DAY_AMOUNT_SUM" VARCHAR(100),
"DAY_HBAMOUNT_SUM" VARCHAR(100),
"DAY" INT,
"MONTH" INT,
"YEAR" INT,
"DATE_COLUMN" VARCHAR(8188),
"CREATOR" VARCHAR(64) DEFAULT '1' NOT NULL,
"CREATE_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL,
"UPDATER" VARCHAR(64) DEFAULT '',
"UPDATE_TIME" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL,
"DELETED" TINYINT DEFAULT 0 NOT NULL,
"DROP_OUT_SUM" VARCHAR(50),
"TRANSFERS_SUM" VARCHAR(50),
"GRADUATE_SUM" VARCHAR(50),
NOT CLUSTER PRIMARY KEY("ID")) STORAGE(ON "test", CLUSTERBTR);
查询SQL:
SELECT year,
month,
SUM(offline_stu_sum) AS offline_stu_sum,
SUM(online_stu_sum) AS online_stu_sum,
SUM(day_amount_sum) AS day_amount_sum,
SUM(day_hbamount_sum) AS day_hbamount_sum
FROM mmt
WHERE deleted = 0
AND org_id IN (?)
AND date_format(date_column, '%Y') = date_format('2023-12-04 14:09:39', '%Y')
GROUP BY month,
year
ORDER BY month DESC

有没有大佬看看图片.png

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