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

[Larry O'Leary]

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 at redhat.com>
Red Hat, Inc.