mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-10 15:22:56 +00:00
19d2d77b41
* feat: support parsing large timestamp values * chore: update sqlness tests * fix: tests * fix: allow larger window
32 lines
1.2 KiB
SQL
32 lines
1.2 KiB
SQL
SELECT timestamp ' 2017-07-23 13:10:11 ';
|
|
|
|
SELECT timestamp ' 2017-07-23 13:10:11 ';
|
|
|
|
CREATE TABLE timestamp_with_precision (ts TIMESTAMP(6) TIME INDEX, cnt INT);
|
|
|
|
INSERT INTO timestamp_with_precision(ts,cnt) VALUES ('2023-04-04 08:00:00.0052+0000', 1);
|
|
|
|
INSERT INTO timestamp_with_precision(ts,cnt) VALUES ('2023-04-04 08:00:00.0052+0800', 2);
|
|
|
|
INSERT INTO timestamp_with_precision(ts,cnt) VALUES ('+100000-01-01 00:00:01.5Z', 3);
|
|
|
|
INSERT INTO timestamp_with_precision(ts,cnt) VALUES ('-262144-01-01 00:00:00Z', 4);
|
|
|
|
INSERT INTO timestamp_with_precision(ts,cnt) VALUES ('+262143-12-31 23:59:59Z', 5);
|
|
|
|
INSERT INTO timestamp_with_precision(ts,cnt) VALUES ('-262144-01-01 00:00:00Z', 6);
|
|
|
|
INSERT INTO timestamp_with_precision(ts,cnt) VALUES ('+262143-12-31 23:59:59.999Z', 7);
|
|
|
|
INSERT INTO timestamp_with_precision(ts,cnt) VALUES ('-262144-01-01 00:00:00Z', 8);
|
|
|
|
INSERT INTO timestamp_with_precision(ts,cnt) VALUES ('+262143-12-31 23:59:59.999999Z', 9);
|
|
|
|
INSERT INTO timestamp_with_precision(ts,cnt) VALUES ('1677-09-21 00:12:43.145225Z', 10);
|
|
|
|
INSERT INTO timestamp_with_precision(ts,cnt) VALUES ('2262-04-11 23:47:16.854775807Z', 11);
|
|
|
|
SELECT * FROM timestamp_with_precision ORDER BY ts ASC;
|
|
|
|
DROP TABLE timestamp_with_precision;
|