[
https://issues.jboss.org/browse/TEIID-3231?page=com.atlassian.jira.plugin...
]
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)