OracleTimeStamp Structure

In This Topic

Represents the Oracle TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE data types.

Syntax

Visual Basic
C#

'Declaration
 
Public Structure OracleTimeStamp 
   Inherits System.ValueType
   Implements System.Data.SqlTypes.INullable, System.IComparable, System.Xml.Serialization.IXmlSerializable

public struct OracleTimeStamp : System.ValueType, System.Data.SqlTypes.INullable, System.IComparable, System.Xml.Serialization.IXmlSerializable

Remarks

To obtain an OracleTimeStamp object call the OracleDataReader.GetOracleTimeStamp method of the OracleDataReader or OracleParameter class.

When Oracle Client and server have timezone files of different versions, Oracle Client returns the following error when reading TIMESTAMP WITH TIME ZONE values with time zone explicitly specified by name: "ORA-01805: possible error in date/time operation". This error means that there is a chance, that you will get a timestamp with incorrect time zone value. dotConnect for Oracle ignores this error and returns an OracleTimeStamp object in this case, but it is not guaranteed that you will get correct time zone values in such case.

Inheritance Hierarchy

System.Object
System.ValueType
Devart.Data.Oracle.OracleTimeStamp

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

OracleTimeStamp Members
Devart.Data.Oracle Namespace

Send Feedback