[
https://issues.apache.org/jira/browse/PHOENIX-1485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabriel Reid updated PHOENIX-1485:
----------------------------------
Attachment: PHOENIX-1485.2.patch
Thanks for that, your version is way better of course, as well as acting more
correctly should there be a poorly-behaved built-in function that has a
parameter with a default value followed by one without a default parameter.
Here's the patch with that change made, as well as allowing all invocations of
TO_DATE to make use of the configured time zone, while remaining backwards
compatible (i.e. defaulting to GMT).
> Date columns should be displayed without timezone offset
> --------------------------------------------------------
>
> Key: PHOENIX-1485
> URL: https://issues.apache.org/jira/browse/PHOENIX-1485
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.1
> Reporter: noam bulvik
> Attachments: PHOENIX-1485.1.patch, PHOENIX-1485.2.patch,
> PHOENIX-1485.patch
>
>
> 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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
