mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-03-28 21:10:37 +00:00
e64c31e59a
* chore: upgrade DataFusion family Signed-off-by: luofucong <luofc@foxmail.com> * use main proto Signed-off-by: luofucong <luofc@foxmail.com> * fix ci Signed-off-by: luofucong <luofc@foxmail.com> --------- Signed-off-by: luofucong <luofc@foxmail.com>
31 lines
1.5 KiB
Plaintext
31 lines
1.5 KiB
Plaintext
-- SQLNESS REPLACE (\d+:\d+:\d+\.\d+) TIME
|
|
-- SQLNESS REPLACE [\s\-]+
|
|
select current_time();
|
|
|
|
++|current_time()|++|TIME|++
|
|
|
|
select GREATEST('1999-01-30', '2023-03-01');
|
|
|
|
+-------------------------------------------------+
|
|
| greatest(Utf8("1999-01-30"),Utf8("2023-03-01")) |
|
|
+-------------------------------------------------+
|
|
| 2023-03-01 |
|
|
+-------------------------------------------------+
|
|
|
|
select GREATEST('2000-02-11'::Date, '2020-12-30'::Date);
|
|
|
|
+-------------------------------------------------+
|
|
| greatest(Utf8("2000-02-11"),Utf8("2020-12-30")) |
|
|
+-------------------------------------------------+
|
|
| 2020-12-30 |
|
|
+-------------------------------------------------+
|
|
|
|
select GREATEST('2021-07-01 00:00:00'::Timestamp, '2024-07-01 00:00:00'::Timestamp);
|
|
|
|
+---------------------------------------------------------------------------------------------------------------------------------------+
|
|
| greatest(arrow_cast(Utf8("2021-07-01 00:00:00"),Utf8("Timestamp(ms)")),arrow_cast(Utf8("2024-07-01 00:00:00"),Utf8("Timestamp(ms)"))) |
|
|
+---------------------------------------------------------------------------------------------------------------------------------------+
|
|
| 2024-07-01T00:00:00 |
|
|
+---------------------------------------------------------------------------------------------------------------------------------------+
|
|
|