为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。 【DM版本】:DM8 【操作系统】：WINWDOS 【CPU】: 【问题描述】*：时间间隔类型的字段怎么插入数据通过DM客户端工具
–建表 create table “T1” ( “C1” INTERVAL YEAR(2) TO MONTH, “C2” INTERVAL MONTH(2), “C3” INTERVAL DAY(2), “C4” INTERVAL HOUR(2), “C5” INTERVAL MINUTE(2), “C6” INTERVAL SECOND(2, 6) ); –插入数据 INSERT INTO T1 VALUES(INTERVAL ‘0015 08’ YEAR TO MONTH,INTERVAL ‘0015’ MONTH,INTERVAL ‘30’ DAY ,INTERVAL ‘48’ HOUR,INTERVAL ‘60’ MINUTE,INTERVAL ‘51.1’ SECOND); –查询 SELECT * FROM T1;
–建表
create table “T1”
(
“C1” INTERVAL YEAR(2) TO MONTH,
“C2” INTERVAL MONTH(2),
“C3” INTERVAL DAY(2),
“C4” INTERVAL HOUR(2),
“C5” INTERVAL MINUTE(2),
“C6” INTERVAL SECOND(2, 6)
);
–插入数据
INSERT INTO T1 VALUES(INTERVAL ‘0015 08’ YEAR TO MONTH,INTERVAL ‘0015’ MONTH,INTERVAL ‘30’ DAY ,INTERVAL ‘48’ HOUR,INTERVAL ‘60’ MINUTE,INTERVAL ‘51.1’ SECOND);
–查询
SELECT * FROM T1;