[DRILL-5141] Difference in output date format on sqlline vs Drill's Web UI

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.9.0
• Fix Version/s: 1.15.0
• Component/s: Execution - Flow
• Assignee: Unassigned
• Reporter: Khurram Faraaz
• Created: 20/Dec/16 13:14
• Updated: 24/Dec/18 19:04
• Resolved: 24/Dec/18 09:27

Description

Difference in output date format on sqlline vs Drill's Web UI
Drill 1.9.0 git commit ID : 4c1b420b

From sqlline prompt

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)

The same query returns a date in a different output format on the web UI

2016-09-22T00:00:00.000Z

Issue Links

• Is contained by: DRILL-5332 DateVector support uses questionable conversions to a time