mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2025-12-28 00:42:56 +00:00
f387a09535
* fix: refactor and fix to_unixtime * fix: sqlness tests * feat: supports date type * fix: test * feat: supports datetime type * refactor: convert_to_seconds
40 lines
636 B
SQL
40 lines
636 B
SQL
select 1;
|
|
|
|
select 2 + 3;
|
|
|
|
select 4 + 0.5;
|
|
|
|
select "a";
|
|
|
|
select "A";
|
|
|
|
select * where "a" = "A";
|
|
|
|
select TO_UNIXTIME('2023-03-01T06:35:02Z');
|
|
|
|
select TO_UNIXTIME(' 2023-03-01T06:35:02Z ');
|
|
|
|
select TO_UNIXTIME(2);
|
|
|
|
select TO_UNIXTIME('2023-03-01');
|
|
|
|
select TO_UNIXTIME('2023-03-01'::date);
|
|
|
|
select TO_UNIXTIME('2023-03-01 08:00:00+0000');
|
|
|
|
create table test_unixtime(a int, b timestamp_sec time index);
|
|
|
|
DESC TABLE test_unixtime;
|
|
|
|
insert into test_unixtime values(27, 27);
|
|
|
|
select * from test_unixtime;
|
|
|
|
select a from test_unixtime;
|
|
|
|
select b from test_unixtime;
|
|
|
|
select TO_UNIXTIME(b) from test_unixtime;
|
|
|
|
DROP TABLE test_unixtime;
|