My Oracle Support Banner

ODPM : OracleDataReader.getValue Returns DateTime Instead a DateTimeOffset For TIMESTAMP WITH TIME ZONE Datatype (Doc ID 3063071.1)

Last updated on DECEMBER 15, 2024

Applies to:

Oracle Data Provider for .NET - Version 21.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

In a database, when a table column is defined with the TIMESTAMP WITH TIME ZONE data type, an ODP.NET Managed application using the OracleDataReader.GetValue method retrieves the value as a DateTime instead of a DateTimeOffset. As a workaround, for each record, you need to check if the column's data type is OracleDbType.TimeStampTZ and
then invoke the appropriate method to retrieve the correct value.

Changes

Database Script :

 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.