[teiid-issues] [JBoss JIRA] (TEIID-3231) Timezone of DV server has influence on Date and Timestamp columns in some data sources

[Steven Hawkins (JIRA)]

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

Steven Hawkins commented on TEIID-3231:
---------------------------------------

>From the BZ it says JDG, MongoDB and Solr are affected.  

At least for JDG and MongoDB there is no remote notion of a Calendar based timestamp.  That is to say it's all UTC so you would expect date/time/timestamp values to display differently in different local timezones vs. the remote.  I assume that Solr is the same.  This is not entirely undesirable behavior if you want to keep the original UTC value.

The approaches would be to have the respective translators updated with a server timezone setting (similar to JDBC) and have the translator adjust the utc value to keep the calendar fields consistent.  Or don't work an enhancement and let the user manually use the modifytimezone system function.

> Timezone of DV server has influence on Date and Timestamp columns in some data sources
> --------------------------------------------------------------------------------------
>
>                 Key: TEIID-3231
>                 URL: https://issues.jboss.org/browse/TEIID-3231
>             Project: Teiid
>          Issue Type: Bug
>          Components: Misc. Connectors
>    Affects Versions: 8.7.1
>            Reporter: Van Halbert
>            Assignee: Steven Hawkins
>
> Timezone of DV server has influence on Date and Timestamp columns in some data sources



--
This message was sent by Atlassian JIRA
(v6.3.8#6338)