1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| create table tab0
( C0 integer not null identity primary key
, C1 date not null
, C2 time not null
, C3 decimal(7,3) not null
)
;
insert into tab0 (C1, C2, C3)
values ('2020-12-10', '00:00:00', 65.642),
('2020-12-10', '00:01:00', 66.269),
('2020-12-10', '00:02:00', 60.340),
('2020-12-10', '00:04:00', 42.678),
('2020-12-10', '00:05:00', 82.340),
('2020-12-10', '00:06:00', 48.123),
('2020-12-10', '00:07:00', 49.005),
('2020-12-10', '00:08:00', 52.456),
('2020-12-10', '00:09:00', 54.707),
('2020-12-10', '00:10:00', 55.212),
('2020-12-10', '00:11:00', 34.902),
('2020-12-10', '00:12:00', 78.304),
('2020-12-10', '00:13:00', 61.652),
('2020-12-10', '00:14:00', 55.480)
;
create table tab1
( C0 integer not null identity primary key
, C1 date not null
, C2 time not null
, C3 decimal(7,3) not null
, C4 smallint not null
)
; |
Partager