cgivre commented on PR #2638:
URL: https://github.com/apache/drill/pull/2638#issuecomment-1236342717
@jnturton Thanks for this. IMHO this will be a MAJOR improvement in
usability. I have a question about date conversions. Let's say we have a
query like this:
```sql
SELECT...
FROM ...
WHERE dateField > '2020-01-01'
```
Queries like that will work in MySQL and other RDBMS. In Drill I think they
won't fail, but the results are not what people expect. For cases like this,
would `'2020-01-01'` be automatically cast to a date? Would the same thing
happen in situations like:
```
DATE_DIFF('2020-01-01', '2021-01-01')
```
--
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
