Language Reference Guide : A. System Constants and Keywords : System Constants : DatatypeCode Settings
 
Share this page                  
DatatypeCode Settings
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