Sha256: ac1a439cea05fa887ce308bb222612fb234edddc804b50b68c24c7417621a638
Contents?: true
Size: 887 Bytes
Versions: 10
Compression:
Stored size: 887 Bytes
Contents
DROP TABLE load;
CREATE TABLE load (
ts TIMESTAMP NOT NULL,
note VARCHAR2(10)
);
INSERT INTO load (ts, note) VALUES (TO_TIMESTAMP('2016-11-02 01:00:01', 'YYYY-MM-DD HH24:MI:SS'), 'first');
INSERT INTO load (ts, note) VALUES (TO_TIMESTAMP('2016-11-02 02:00:02', 'YYYY-MM-DD HH24:MI:SS'), 'first');
INSERT INTO load (ts, note) VALUES (TO_TIMESTAMP('2016-11-02 03:00:03', 'YYYY-MM-DD HH24:MI:SS'), 'first');
INSERT INTO load (ts, note) VALUES (TO_TIMESTAMP('2016-11-02 04:00:04', 'YYYY-MM-DD HH24:MI:SS'), 'first');
INSERT INTO load (ts, note) VALUES (TO_TIMESTAMP('2016-11-02 04:00:05.111001', 'YYYY-MM-DD HH24:MI:SS.FF6'), 'first');
INSERT INTO load (ts, note) VALUES (TO_TIMESTAMP('2016-11-02 04:00:05.222002', 'YYYY-MM-DD HH24:MI:SS.FF6'), 'first');
INSERT INTO load (ts, note) VALUES (TO_TIMESTAMP('2016-11-02 04:00:05.333003', 'YYYY-MM-DD HH24:MI:SS.FF6'), 'first');
EXIT;
Version data entries
10 entries across 10 versions & 1 rubygems