[jira] [Comment Edited] (DRILL-5141) Difference in output date format on sqlline vs Drill's Web UI
[ https://issues.apache.org/jira/browse/DRILL-5141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16152624#comment-16152624 ] Vitalii Diravka edited comment on DRILL-5141 at 12/24/18 7:03 PM: -- Once [DRILL-5332|https://issues.apache.org/jira/browse/DRILL-5332] is resolved, this issue will gone. was (Author: vitalii): Once [DRILL-5332|https://issues.apache.org/jira/browse/DRILL-5141] is resolved, this issue will gone. > Difference in output date format on sqlline vs Drill's Web UI > - > > Key: DRILL-5141 > URL: https://issues.apache.org/jira/browse/DRILL-5141 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Flow >Affects Versions: 1.9.0 >Reporter: Khurram Faraaz >Priority: Minor > Fix For: 1.15.0 > > > Difference in output date format on sqlline vs Drill's Web UI > Drill 1.9.0 git commit ID : 4c1b420b > From sqlline prompt > {noformat} > 0: jdbc:drill:schema=dfs.tmp> SELECT cast('2016/09/22' as date) FROM > (VALUES(1)); > +-+ > | EXPR$0| > +-+ > | 2016-09-22 | > +-+ > 1 row selected (0.474 seconds) > {noformat} > The same query returns a date in a different output format on the web UI > {noformat} > 2016-09-22T00:00:00.000Z > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Comment Edited] (DRILL-5141) Difference in output date format on sqlline vs Drill's Web UI
[ https://issues.apache.org/jira/browse/DRILL-5141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16728291#comment-16728291 ] Volodymyr Vysotskyi edited comment on DRILL-5141 at 12/24/18 9:25 AM: -- [~khfaraaz], looks like this issue was resolved. Both sqlline and web-UI return {{2016-09-22}}. was (Author: vvysotskyi): [~khfaraaz], looks like this issue was resolved. Both sqlline and web-UI returns \{{2016-09-22}}. > Difference in output date format on sqlline vs Drill's Web UI > - > > Key: DRILL-5141 > URL: https://issues.apache.org/jira/browse/DRILL-5141 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Flow >Affects Versions: 1.9.0 >Reporter: Khurram Faraaz >Priority: Minor > > Difference in output date format on sqlline vs Drill's Web UI > Drill 1.9.0 git commit ID : 4c1b420b > From sqlline prompt > {noformat} > 0: jdbc:drill:schema=dfs.tmp> SELECT cast('2016/09/22' as date) FROM > (VALUES(1)); > +-+ > | EXPR$0| > +-+ > | 2016-09-22 | > +-+ > 1 row selected (0.474 seconds) > {noformat} > The same query returns a date in a different output format on the web UI > {noformat} > 2016-09-22T00:00:00.000Z > {noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)