为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
CREATE TABLE "T5236"
(
"A" INT,
"B" DATETIME(6)WITH TIME ZONE,
"C" TIMESTAMP(6),
"D" VARCHAR(10)) STORAGE(ON "MAIN", CLUSTERBTR) ;
INSERT INTO T5236 VALUES(0129,'2023-01-29 17:01:01','2023-01-29 17:01:01','2023');
INSERT INTO T5236 VALUES(0130,'2023-01-30 18:01:01','2023-01-30 18:01:01','2023');
INSERT INTO T5236 VALUES(0131,'2023-01-31 17:01:01','2023-01-31 17:01:01','2023');
INSERT INTO T5236 VALUES(0131,'2023-01-31 18:01:01','2023-01-31 18:01:01','2023');
INSERT INTO T5236 VALUES(0201,'2023-02-01 01:01:01','2023-02-01 01:01:01','2023');
INSERT INTO T5236 VALUES(0201,'2023-02-01 17:01:01','2023-02-01 17:01:01','2023');
INSERT INTO T5236 VALUES(0201,'2023-02-01 18:01:01','2023-02-01 18:01:01','2023');
INSERT INTO T5236 VALUES(0202,'2023-02-02 01:01:01','2023-02-02 01:01:01','2023');
INSERT INTO T5236 VALUES(0202,'2023-02-02 01:01:01','2023-02-02 01:01:01','2023');
INSERT INTO T5236 VALUES(0203,'2023-02-03 01:01:01','2023-02-03 01:01:01','2023');
INSERT INTO T5236 VALUES(0227,'2023-02-27 01:01:01','2023-02-27 01:01:01','2023');
INSERT INTO T5236 VALUES(0228,'2023-02-28 01:01:01','2023-02-28 01:01:01','2023');
INSERT INTO T5236 VALUES(0228,'2023-02-28 13:01:01','2023-02-28 13:01:01','2023');
INSERT INTO T5236 VALUES(0301,'2023-03-01 05:01:01','2023-03-01 05:01:01','2023');
INSERT INTO T5236 VALUES(0302,'2023-03-02 08:01:01','2023-03-02 08:01:01','2023');
SELECT * FROM T5236 WHERE B>='2023-02-01 00:00:00' AND B<='2023-03-10 23:59:59.999' ;
数据库版本:
你好,该问题已反馈,此问题在后续下一季度新版本中已解决,届时可通过官网或在线服务平台下载最新安装版本使用。
看起来是 datetime带时区的问题, WITH TIME ZONE 去掉试试