Data Types
Supported Data Types and Type Conversions
The following table lists all of the supported data types, and the conversions allowed for each data type.
| Convert From | Convert To | |
|
BOOLEAN |
VARCHAR, BOOLEAN, OBJECT |
java.lang.Boolean |
|
VARCHAR |
All types |
java.lang.String |
|
TINYINT |
VARCHAR, BOOLEAN, SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE, OBJECT |
java.lang.Byte |
|
SMALLINT |
VARCHAR, SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE, OBJECT |
java.lang.Short |
|
INTEGER |
VARCHAR, SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE, OBJECT |
java.lang.Integer |
|
BIGINT |
VARCHAR, SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE, OBJECT |
java.lang.Long |
|
DECIMAL |
VARCHAR, SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE, OBJECT |
java.math.BigDecimal |
|
REAL |
VARCHAR, SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE, OBJECT |
java.lang.Float |
|
DOUBLE |
VARCHAR, SMALLINT, INTEGER, BIGINT, DECIMAL, REAL, DOUBLE, OBJECT |
java.lang.Double |
|
DATE |
VARCHAR, DATE, TIME, TIMESTAMP, TIMESTAMP WITH TIME ZONE, OBJECT |
java.time.LocalDate |
|
TIME |
VARCHAR, DATE, TIME, TIMESTAMP, TIMESTAMP WITH TIME ZONE, OBJECT |
java.time.LocalTime |
|
TIMESTAMP |
VARCHAR, DATE, TIME, TIMESTAMP, TIMESTAMP WITH TIME ZONE, OBJECT |
java.time.LocalDateTime |
|
OBJECT |
All types |
Any Java class |