[teiid-dev] Connectors, data source, and timestamps

I have been looking into some legacy issues regarding date/time values and time zone offsets. I am well aware that the DBMS recommendation is to store time values in a consistent, predetermined time zone. I think in principle this recommendation works but what about a federated query engine that has clients connecting from many different geographies? Also, how about the Oracle TIMESTAMP WITH TIME ZONE data type? It seems that this even complicates matters more? Are the connectors handling such logic? Do they need to? Does Teiid plan to offer a recommendation regarding setting and retrieving of time values and appropriate time zone or locale information? -- Larry O'Leary <loleary(a)redhat.com&gt; Red Hat, Inc.