Date and Timestamp columns in the resultset are affected by a time zone of DV server. This problem occurs in JDG, MongoDB and Solr data sources. DV server should return always the same values for Date and Timestamp columns even though the time zone of DV server is changed.
The engineer considers this an enhancement and would like to target this to the 8.10 branch, which means it would be in DV 6.2.
I have no problem to postpone this until DV 6.2.
Moved to DV 6.3, as where TEIID 8.10 will be included.
Steven Hawkins <shawkins> updated the status of jira TEIID-3231 to Resolved
MongoDB values are in utc https://docs.mongodb.org/v3.0/reference/bson-types/#document-bson-type-timestamp so it's expected that their display will change if the Teiid server is in a different timezone.
Steven Hawkins <shawkins> updated the status of jira TEIID-3231 to Closed
all source dates are effectively UTC which means that it's expected that they will display differently if the teiid server timezone changes.