[PHOENIX-1485] Date columns should be displayed without timezone offset

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.1.0
• Fix Version/s: 4.3.0, 3.3.0, 3.2.2, 4.2.2
• Assignee: Gabriel Reid
• Reporter: noam bulvik
• Created: 26/Nov/14 06:17
• Updated: 10/Dec/18 13:24
• Resolved: 03/Dec/14 16:37

Description

when date or timestamp column queried the value is the date with timezone offset. this is not how it is handled by other jdbc drivers like oracle and impala. and it seems strange that when I have text file with specific date and I use bulk loader to store it , when I will use select * .. I will get different dates then the one in the file (because of the time zone offset)
by default the date should be displayed without any offset.
it will be nice to have an option to add the timezone offset the option in the driver

Issue Links

• causes: PHOENIX-5066 The TimeZone is incorrectly used during writing or reading data
• is duplicated by: PHOENIX-997 Timestamp date type default format with GMT time zone