mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2025-12-28 00:42:56 +00:00
04dbd835a1
* feat: support greatest function * feat: make greatest take date_type as input * fix: move sqlness test into common/function/time.sql * fix: avoid using unwarp * fix: use downcast * refactor: simplify arrow cast
23 lines
750 B
Plaintext
23 lines
750 B
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 |
|
|
+-------------------------------------------------+
|
|
|