[GitHub] [arrow-datafusion] alamb commented on issue #6180: `INTERVAL` + timestamp and `INTERVAL` + date not supported (but timestamp + `INTERVAL` and date + `INTERVAL` is)

["alamb (via GitHub)" <gi...@apache.org>]

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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org