Description
The OraTimeStamp object represents the Oracle TIMESTAMP and Oracle TIMESTAMP
WITH LOCAL TIME ZONE data types and provides methods for operations on these two
Oracle data types. The OraTimeStamp represents a date time value that stores
the following information: year, day, hour, minute, second, and nanosecond.
Remarks
The OraTimeStamp object is created by the OraSession.CreateTimeStamp method or by calling the Clone method on an existing OraTimeStamp object.
An OraTimeStamp object can be bound using the ServerTypes ORATYPE_TIMESTAMP
and ORATYPE_TIMESTAMPLTZ. This allows the binding of a value to a parameter
associated with an Oracle TIMESTAMP or an Oracle TIMESTAMP WITH LOCAL TIME ZONE
datatype in a SQL or PL/SQL statement respectively.
When binding a string
associated with an TIMESTAMP, or an TIMESTAMP WITH LOCAL TIME ZONE datatypes,
the ServerType must be specified to be a string type (for example,
ORATYPE_VARCHAR2, ORATYPE_STRING) and the string must be in the format
specified by NLS_TIMESTAMP_FORMAT.