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 laterInformation 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 |