[DRILL-7989] Use the UTC formatter in the JSON reader

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.20.0
• Assignee: Cong Luo
• Reporter: Cong Luo
• Created: 22/Aug/21 15:54
• Updated: 11/Feb/22 06:43
• Resolved: 31/Jan/22 09:51

Description

MongoDB use the UTC format to specify the date value by default. But the JSON reader (old version) use the fixed date formatter : "yyyy-MM-dd'T'HH:mm:ss.SSSXX". Need to change to the "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'" format.

Issue Links

• links to: #2298