Page 1 of 1

How to read DateTimeOffset from OracleArrayDataReader

Posted: Mon 25 Mar 2019 08:49
by pakarjon
OracleDataReader has "GetDateTimeOffset" -method to retrieve timestamp from data.

OracleArrayDataReader however does not have similar method and that's the reader I get when reading nested table data from object view.

How should I handle timestamp value reading with OracleArrayDataReader?

Re: How to read DateTimeOffset from OracleArrayDataReader

Posted: Mon 25 Mar 2019 13:07
by Pinturiccio
Yes, OracleArrayDataReader does not have the GetDateTimeOffset method. We will investigate the possibility to implement this method and post here when we get the results.

Re: How to read DateTimeOffset from OracleArrayDataReader

Posted: Wed 27 Mar 2019 13:54
by Pinturiccio
We have added GetOracleTimeStamp, GetDateTimeOffset, and GetTimeSpan methods to OracleArrayDataReader. We have also fixed some bugs with reading data via OracleArrayDataReader. We will post here when the corresponding build of dotConnect for Oracle is available for download.

Re: How to read DateTimeOffset from OracleArrayDataReader

Posted: Fri 29 Mar 2019 11:07
by Pinturiccio
New build of dotConnect for Oracle 9.6.725 is available for download.
It can be downloaded from https://www.devart.com/dotconnect/oracle/download.html (trial version) or from Customer Portal (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=38518