'Declaration Public Enum TdType Inherits System.Enum Implements System.IComparable, System.IConvertible, System.IFormattable
'Usage Dim instance As TdType
public enum TdType : System.Enum, System.IComparable, System.IConvertible, System.IFormattable
public enum class TdType : public System.Enum, System.IComparable, System.IConvertible, System.IFormattable
| Member | Description | ||||
|---|---|---|---|---|---|
| AnyType | Represents an object (i.e. Parameter) whose data type is defined at runtime. It is conceptually similar to a Variant type. The TD_ANYTYPE type is supported as a parameter type for functions (domain specific system functions and UDFs), user defined methods and external stored procedures (XSPs). | ||||
| BigInt | Represents 64 bit signed integer that has a range of range of –9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.
Application calls TdDataReader.GetInt64 to retrieve the value. Type Mappings:
| ||||
| Blob | Represents a Binary Large Object BLOB(n) where n is the maximum number of bytes ranging from 1 to 2G.
Application calls TdDataReader.GetTdBlob to retrieve a TdBlob object. Application can also call TdDataReader.GetBytes to retrieve all or portion of the BLOB when operating in CommandBehavior.SequentialAccess mode. Type Mappings:
| ||||
| Byte | Represents a fixed-length binary data BYTE(n) where n is the number of bytes ranging from 1 to 64000.
Application calls TdDataReader.GetBytes to retrieve all or a portion of the binary data. Type Mappings:
| ||||
| ByteInt | 8 bit signed integer ranging from -128 to 127.
Application calls TdDataReader.GetInt16 to retrieve the value. Type Mappings:
| ||||
| Char | Represents a fixed-length character string CHAR(n). Teradata automatically translates between the session character set and target column.
Application calls TdDataReader.GetString to retrieve the value. Type Mappings:
| ||||
| Clob | Represents a Character Large Object CLOB(n) where n is the maximum number of characters ranging from 1 to 2G.
Application calls TdDataReader.GetTdClob to retrieve a TdClob object. An Application can also call TdDataReader.GetChars or TdDataReader.GetChars to retrieve all or a portion of the CLOB when operating in CommandBehavior.SequentialAccess mode. Type Mappings:
| ||||
| Date | Date value with YYYY-MM-DD format. Ranging from 1-1-1 to 9999-12-31.
Application calls TdDataReader.GetDate or TdDataReader.GetDateTime to retrieve the value. NOTE: The time for the resulting System.DateTime is set to 00:00:00.0000000 (midnight). Type Mappings:
| ||||
| Decimal | DECIMAL(n, m) represents a decimal number of n digits (precision), with m (scale) of those n digits to the right of the decimal point. The range for n is from 1 to 18. The range for m is from 0 through n.
Application calls TdDataReader.GetDecimal to retrieve the value. Type Mappings:
| ||||
| Double | Double Precision 64-bit number. Ranging from -1.7976E308 to 1.7976E308.
Application calls TdDataReader.GetDouble to retrieve the value. Type Mappings:
| ||||
| Graphic | Represents a fixed-length UNICODE character string. GRAPHIC represents Unicode characters defined by IBM corporation for DB2.
Application calls TdDataReader.GetString to retrieve the value. Type Mappings:
| ||||
| Integer | 32 bit signed integer. Ranging from -2,147,483,648 to 2,147,483,647.
Application calls TdDataReader.GetInt32 to retrieve the value. Type Mappings:
| ||||
| IntervalDay | A time interval represented in Days. Day-Precision is from 1 to 4. Precision defaults to 2. Therefore the value range of values is from -'9999' to '9999'.
Application calls TdDataReader.GetTdIntervalDay to retrieve the value. Type Mappings:
| ||||
| IntervalDayToHour | A time interval represented in Days and Hours. Day-Precision is from 1 to 4. Precision defaults to 2. Therefore the range of values is from -'9999 23' to '9999 23'.
Application calls TdDataReader.GetTdIntervalDayToHour to retrieve the value. Type Mappings:
| ||||
| IntervalDayToMinute | A time interval represented in Days, Hours and Minutes. Day-Precision is from 1 to 4. Precision defaults to 2. Therefore the range of values is from -'9999 23:59' to '9999 23:59'.
Application calls TdDataReader.GetTdIntervalDayToMinute to retrieve the value. Type Mappings:
| ||||
| IntervalDayToSecond | A time interval represented in Days, Hours, Minutes and Seconds. Day-Precision is from 1 to 4. Precision defaults to 2. The fractional seconds scale is 0 to 6 and defaults to 6. Therefore the range of values is from -'9999 23:59:59.999999' to '9999 23:59:59.999999'.
Application calls TdDataReader.GetTdIntervalDayToSecond to retrieve the value. Type Mappings:
| ||||
| IntervalHour | A time interval represented in Hours. Hour-Precision is from 1 to 4. Precision defaults to 2. Therefore the range of values is from -'9999' to '9999'.
Application calls TdDataReader.GetTdIntervalHour to retrieve the value. Type Mappings:
| ||||
| IntervalHourToMinute | A time interval represented in Hours and Minutes. Hour-Precision is from 1 to 4. Precision defaults to 2. Therefore the range of values is from -'9999:59' to '9999:59'.
Application calls TdDataReader.GetTdIntervalHourToMinute to retrieve the value. Type Mappings:
| ||||
| IntervalHourToSecond | A time interval represented in Hours, Minutes, Seconds and fractional seconds. Hour-Precision is from 1 to 4. Precision defaults to 2. The fractional seconds scale is 0 to 6 and defaults to 6. Therefore the range of values is from -'9999:59:59.999999' to '9999:59:59.999999'.
Application calls TdDataReader.GetTdIntervalHourToSecond to retrieve the value. Type Mappings:
| ||||
| IntervalMinute | A time interval represented in Minutes. Precision is from 1 to 4 and defaults to 2. Therefore the range of values is from -'9999' to '9999'.
Application calls TdDataReader.GetTdIntervalMinute to retrieve the value. Type Mappings:
| ||||
| IntervalMinuteToSecond | A time interval represented in Minutes and Seconds. Minute-Precision is from 1 to 4 and defaults to 2. The fractional scale is 0 to 6 and defaults to 6. Therefore the range of values is from -'9999:59.999999' to '9999:59.999999'.
Application calls TdDataReader.GetTdIntervalMinuteToSecond to retrieve the value. Type Mappings:
| ||||
| IntervalMonth | A time interval represented in Months. Ranging from -'9999' to '9999'. Month-Precision is from 1 to 4. Precision defaults to 2.
Application calls TdDataReader.GetTdIntervalMonth to retrieve the value. Type Mappings:
| ||||
| IntervalSecond | A time interval represented in Seconds. Second-Precision is from 1 to 4 and defaults to 2. The fractional seconds scale is 0 to 6 and defaults to 6. Therefore the range of values is from -'9999.999999' to '9999.999999'.
Application calls TdDataReader.GetTdIntervalSecond to retrieve the value. Type Mappings:
| ||||
| IntervalYear | A time interval represented in Years. Ranging from -'9999' to '9999'. Year-Precision is from 1 to 4. Precisions defaults to 2.
Application calls TdDataReader.GetTdIntervalYear to retrieve the value. Type Mappings:
| ||||
| IntervalYearToMonth | A time interval represented in Years and Months. Ranging from -'9999–12' to '9999–12'. Year-Precision is from 1 to 4. Precision defaults to 2.
Application calls TdDataReader.GetTdIntervalYearToMonth to retrieve the value. Type Mappings:
| ||||
| Json | Represents a variable length JavaScript Object Notation (JSON) object. Application calls TdDataReader.GetString to retrieve the value. Type Mappings:
| ||||
| Number | Number represents a Teradata type NUMBER. The corresponding provider specific type is TdNumber. The range of a NUMBER is ± [1E-130 to 9.99…9E125] as well as 0. It will also support a precision of up to 40 digits. Application calls TdDataReader.GetTdNumber to retrieve the value. Type Mappings:
| ||||
| PeriodDate | A Period of type TdDate that has a format of ('beginning bound', 'ending bound'). Both the beginning and ending bounds have the format yyyy-MM-dd. Application call TdDataReader.GetTdPeriodDate to retrieve the value. Type Mappings:
| ||||
| PeriodTime | A Period of type TdTime that has a format of ('beginning bound', 'ending bound'). Both the beginning and ending bounds have the format HH:mm:ss.(f). The scale can range from 0 to 6. Application call TdDataReader.GetTdPeriodTime to retrieve the value. Type Mappings:
| ||||
| PeriodTimestamp | A Period of type TdTimestamp that has a format of ('beginning bound', 'ending bound'). Both the beginning and ending bounds have the format yyyy-MM-dd HH:mm:ss.(f). The scale can range from 0 to 6. Application call TdDataReader.GetTdPeriodTimestamp to retrieve the value. Type Mappings:
| ||||
| PeriodTimestampWithTimeZone | A Period of type TdTimestampWithTimeZone that has a format of ('beginning bound', 'ending bound'). Both the beginning and ending bounds have the format yyyy-MM-dd HH:mm:ss.(f)±HH:mm. The scale can range from 0 to 6. Application call TdDataReader.GetTdPeriodTimestampWithTimeZone to retrieve the value. Type Mappings:
| ||||
| PeriodTimeWithTimeZone | A Period of type TdTimeWithTimeZone that has a format of ('beginning bound', 'ending bound'). Both the beginning and ending bounds have the format HH:mm:ss.(f)±HH:mm. The scale can range from 0 to 6. Application call TdDataReader.GetTdPeriodTimeWithTimeZone to retrieve the value. Type Mappings:
| ||||
| SmallInt | 16 bit signed integer. Ranging from -32,768 to 32,767.
Application calls TdDataReader.GetInt16 to retrieve the value. Type Mappings:
| ||||
| Time | Time value with HH:mm:ss.(f) format. Teradata supports up to 6 fractional-seconds-precision (i.e. TIME(6)).
Application calls TdDataReader.GetTime to retrieve the value. Type Mappings:
| ||||
| Timestamp | Timestamp (date + time) value with yyyy-MM-dd hh:mm:ss.(f) format. Ranging from 0001-01-01 00:00:00.000000 to 9999-12-31 23:59:59.999999. Teradata supports up to 6 fractional-seconds-precision (i.e. TIMESTAMP(6)).
Application calls TdDataReader.GetDateTime to retrieve the value. Type Mappings:
| ||||
| TimestampWithZone | Timestamp With Time Zone value with yyyy-MM-dd HH:mm:ss.(f)Z±HH:mm format. Teradata supports up to 6 fractional-seconds-precision (i.e. TIMESTAMP(6) WITH TIME ZONE). Note that Timestamp with Time Zone can be cast to Timestamp and is correctly adjusted to represent local time.
Application calls TdDataReader.GetDateTimeOffset to retrieve the value. Type Mappings:
| ||||
| TimeWithZone | Time With Time Zone value with HH:mm:ss.(f)±HH:mm format. Teradata supports up to 6 fractional-seconds-precision (i.e. TIME(6)). Note that Time with Time Zone can be cast to Time and is correctly adjusted to represent local time.
Application calls TdDataReader.GetString to retrieve the value. Type Mappings:
| ||||
| VarByte | Represents a variable-length binary data VARBYTE(n) where n is the number of bytes ranging from 1 to 64000.
Application calls TdDataReader.GetBytes to retrieve all or a portion of the binary data. Type Mappings:
| ||||
| VarChar | Represents a variable-length character string. Teradata automatically translates between the session character set and target column.
Application calls TdDataReader.GetString to retrieve the value. Type Mappings:
| ||||
| VarGraphic | Represents a variable-length UNICODE character string. GRAPHIC represents Unicode characters defined by IBM corporation for DB2.
Application calls TdDataReader.GetString to retrieve the value. Type Mappings:
| ||||
| Xml | Xml represents a Xml document or fragment. Type Mappings:
|
System.Object
System.ValueType
System.Enum
Teradata.Client.Provider.TdType
Target Platforms: Windows 8.1, Windows 10, Windows Server 2012 R2, Windows Server 2016, Windows Server 2019