[teiid-issues] [JBoss JIRA] (TEIID-5362) Odata4 outputs in wrong timezone

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13586410#comment-13586410 ] 

Steven Hawkins commented on TEIID-5362:
---------------------------------------

Also this doesn't seem directly related to OData - the behavior should be confirmed with just JDBC queries as well.

> Odata4 outputs in wrong timezone
> --------------------------------
>
>                 Key: TEIID-5362
>                 URL: https://issues.jboss.org/browse/TEIID-5362
>             Project: Teiid
>          Issue Type: Bug
>          Components: OData
>    Affects Versions: 8.12.13.6_4
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>
> The incoming odata4 request is requesting the records at 08:52Z (specifying UTC time). The DataVirt server (running in US/Chicago time) converts that into SQL to ask the database for records at 03:52 (with no timezone specifier... should be in local time, or US/Chicago). The database should recognize that the 03:52 Local time should be converted back to 08:52Z to match the DB records, however, it is not. This (and other tests), leads us to the conclusion that the database session/connection is actually not using US/Chicago (-5:00) timezone, but is instead using the UTC timezone. Unfortunately, we were not able to confirm either in the logs or in the configuration, where the connection was being set up in UTC timezone.
> .



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)