Description of problem: If translator property _DatabaseTimeZone_ is set, time values are adjusted in "opposite direction" (in compare with date and timestamp values). Note, that I did not change user.timezone system property of the server. > Query SELECT intkey,timevalue,datevalue,timestampvalue FROM source.smalla WHERE intkey = 0 > DatabazeTimeZone=GMT-02 IntKey TimeValue DateValue TimestampValue 0 22:00:00 2000-01-01 2000-01-01 03:00:00.0 > DatabazeTimeZone=GMT-01 IntKey TimeValue DateValue TimestampValue 0 23:00:00 2000-01-01 2000-01-01 02:00:00.0| > DatabazeTimeZone=GMT+00 IntKey TimeValue DateValue TimestampValue 0 00:00:00 2000-01-01 2000-01-01 01:00:00.0| > DatabazeTimeZone=GMT+01 IntKey TimeValue DateValue TimestampValue 0 01:00:00 2000-01-01 2000-01-01 00:00:00.0| > DatabazeTimeZone=GMT+02 IntKey TimeValue DateValue TimestampValue 0 02:00:00 1999-12-31 1999-12-31 23:00:00.0| > DDL CREATE FOREIGN TABLE SmallA (... DateValue date OPTIONS (NATIVE_TYPE 'date', NAMEINSOURCE 'datevalue'), TimeValue time OPTIONS (NATIVE_TYPE 'datetime hour to fraction(1)', NAMEINSOURCE 'timevalue'), TimestampValue timestamp OPTIONS (NATIVE_TYPE 'timestamp', NAMEINSOURCE 'timestampvalue'), ...
Steven Hawkins <shawkins> updated the status of jira TEIID-4364 to Resolved