How do I get Oracle "TIMESTAMP(6) WITH TIME ZONE" to return converted to the Timezone of the MetaMatrix Server?
Issue
- In a previous version of MetaMatrix, columns with Oracle datatype "TIMESTAMP(6) WITH TIME ZONE" return converted to the Timezone of the MetaMatrix Server.
- In version 5.5.3, even with TZ=<timezone> set on the MetaMatrix Server, this column does not convert.
- How do I get Oracle "TIMESTAMP(6) WITH TIME ZONE" to return converted to the Timezone of the MetaMatrix Server in version 5.5.3?
Environment
- MetaMatrix Enterprise Server 5.5.3
- Oracle Database version 9.x or later
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
