How do I get Oracle "TIMESTAMP(6) WITH TIME ZONE" to return converted to the Timezone of the MetaMatrix Server?

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In