jnturton commented on PR #2638:
URL: https://github.com/apache/drill/pull/2638#issuecomment-1243628238
Turns out this particular one isn't possible without breaking other things
that need VARCHAR to go to INT before it goes to DATE.
```
apache drill> select date_diff('2022-09-08', '1970-01-01');
EXPR$0 19243 days 0:00:00
```
So we're stuck with the following for date_diff. There do remain other
automatic casts from VARCHAR to DATE will still succeed though.
```
apache drill> select date_diff(date '2022-09-08', date '1970-01-01');
EXPR$0 19243 days 0:00:00
```
--
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: dev-unsubscr...@drill.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
