alamb commented on issue #6180:
URL:
https://github.com/apache/arrow-datafusion/issues/6180#issuecomment-1533104015
I agree this is a parser problem. INTERVAL + timestamp and INTERVAL+date do
work if the `::interval` cast syntax is used rather than the `interval`. I will
open another bug explaining this
```
❯ select '1 month'::interval + '2012-01-01'::date;
+--------------------------------------+
| Utf8("1 month") + Utf8("2012-01-01") |
+--------------------------------------+
| 2012-02-01 |
+--------------------------------------+
❯ select '1 month'::interval + '2012-01-01'::timestamp;
+--------------------------------------+
| Utf8("1 month") + Utf8("2012-01-01") |
+--------------------------------------+
| 2012-02-01T00:00:00 |
+--------------------------------------+
❯ select '2012-01-01'::date + interval '1 month';
+----------------------------------------------------------------------------+
| Utf8("2012-01-01") + IntervalMonthDayNano("79228162514264337593543950336")
|
+----------------------------------------------------------------------------+
| 2012-02-01
|
+----------------------------------------------------------------------------+
❯ select interval '1 month' + '2012-01-01'::date;
This feature is not implemented: Unsupported interval argument. Expected
string literal, got: BinaryOp { left: Value(SingleQuotedString("1 month")), op:
Plus, right: Cast { expr: Value(SingleQuotedString("2012-01-01")), data_type:
Date } }
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
