Constant Value | Description | Numeric Equivalent |
|---|---|---|
DTC_DATE | Date | 3 |
DTC_ANSIDATE | ANSI date | 4 |
DTC_MONEY | Money | 5 |
DTC_TIME | Time without time zone | 6 |
DTC_TIME_WITH_TZ | Time with time zone | 7 |
DTC_TIME_LOCAL | Time with local time zone | 8 |
DTC_TIMESTAMP | Timestamp without time zone | 9 |
DTC_DECIMAL | Decimal | 10 |
DTC_OBJECT_KEY | Object_key | 11 |
DTC_TABLE_KEY | Table_key | 12 |
DTC_TIMESTAMP_WITH_TZ | Timestamp with time zone | 18 |
DTC_TIMESTAMP_LOCAL | Timestamp with local time zone | 19 |
DTC_CHAR | Char | 20 |
DTC_VARCHAR | Varchar | 21 |
DTC_LONG_VARCHAR | Long varchar | 22 |
DTC_BYTE | Byte | 23 |
DTC_VARBYTE | Byte varying | 24 |
DTC_LONG_BYTE | Long byte | 25 |
DTC_NCHAR | Nchar | 26 |
DTC_NVARCHAR | Nvarchar | 27 |
DTC_LONG_NVARCHAR | Long nvarchar | 28 |
DTC_INTEGER | Integer | 30 |
DTC_FLOAT | Float | 31 |
DTC_C | C | 32 |
DTC_INTERVAL_YTOM | Interval year to month | 33 |
DTC_INTERVAL_DTOS | Interval day to second | 34 |
DTC_TEXT | Text | 37 |
DTC_LONG_TEXT | Long text | 41 |
DTC_OBJECT | Object | 45 |