You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@phoenix.apache.org by "Pedro Boado (Jira)" <ji...@apache.org> on 2019/11/11 10:13:00 UTC

[jira] [Commented] (PHOENIX-5567) Incorrect time zones for convert_tz()

    [ https://issues.apache.org/jira/browse/PHOENIX-5567?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16971426#comment-16971426 ] 

Pedro Boado commented on PHOENIX-5567:
--------------------------------------

Hi [~0x62ash] this could be caused by an outdated java runtime. What java versions are you running in both client and server? https://bugs.java.com/bugdatabase/view_bug.do?bug_id=8064374

> Incorrect time zones for convert_tz()
> -------------------------------------
>
>                 Key: PHOENIX-5567
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5567
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.14.2
>            Reporter: Alex Batyrshin
>            Priority: Major
>
> Looks like convert_tz() uses incorrect (old) timezone information for 'Europe/Moscow'.
> From October 2014 time zone in Moscow is *always*: UTC+03:00, but Phoenix convert summer/winter times to different offset.
> Test cast:
> {code:java}
> 0: jdbc:phoenix:10.73.67.148> select dt as as_is, convert_tz(dt, 'UTC', 'Europe/Moscow') from (select to_timestamp('2019-01-01') dt);
> +--------------------------+---------------------------------+
> |          AS_IS           | DATE '2019-01-01 03:00:00.000'  |
> +--------------------------+---------------------------------+
> | 2019-01-01 00:00:00.000  | 2019-01-01 03:00:00.000         |
> +--------------------------+---------------------------------+
> 1 row selected (0.003 seconds)
> 0: jdbc:phoenix:10.73.67.148> select dt as as_is, convert_tz(dt, 'UTC', 'Europe/Moscow') from (select to_timestamp('2019-07-01') dt);
> +--------------------------+---------------------------------+
> |          AS_IS           | DATE '2019-07-01 04:00:00.000'  |
> +--------------------------+---------------------------------+
> | 2019-07-01 00:00:00.000  | 2019-07-01 04:00:00.000         |
> +--------------------------+---------------------------------+
> 1 row selected (0.004 seconds)
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)