[teiid-issues] [JBoss JIRA] (TEIID-4854) Google translator fails to update timestamp value reformatted after update

Google translator fails to update timestamp value reformatted after update -------------------------------------------------------------------------- Key: TEIID-4854 URL: https://issues.jboss.org/browse/TEIID-4854 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 9.3, 8.12.10.6_3 Reporter: Lucie Fabrikova Assignee: Steven Hawkins Fix For: 10.0, 8.12.x-6.4 Attachments: gs-reformatted-timestamp.log Cell of type timestamp is reformatted after an update. Data inserted from teiid are in format "yyyy-mm-dd hh:mm:ss[.fffffffff]", which is reformatted to "dd/mm/yyyy hh:mm:ss[.fffffffff]". Subsequent update of such row throws exception "Could not convert source column Source.smalla.timestampvalue to the expected runtime type timestamp". Google spreadsheet locale was UK, timezone was set to Berlin.