[ https://issues.apache.org/jira/browse/DRILL-5141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16728291#comment-16728291 ]
Volodymyr Vysotskyi commented on DRILL-5141: -------------------------------------------- [~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)