A newer version of IMDG is available.

View latest

Want to try Hazelcast Platform?

We’ve combined the in-memory storage of IMDG with the stream processing power of Jet to bring you the all new Hazelcast Platform.

Data Types

4.2 4.1 4.0 3.12 3.11 3.10 3.9 3.8 3.7 3.6 3.5

The SQL service supports a set of SQL data types. Every data type is mapped to a Java class that represents the type’s value.

Table 1. SQL Data Types
Type Name Java Class

BOOLEAN

java.lang.Boolean

VARCHAR

java.lang.String

TINYINT

java.lang.Byte

SMALLINT

java.lang.Short

INTEGER

java.lang.Integer

BIGINT

java.lang.Long

DECIMAL

java.math.BigDecimal

REAL

java.lang.Float

DOUBLE

java.lang.Double

DATE

java.time.LocalDate

TIME

java.time.LocalTime

TIMESTAMP

java.time.LocalDateTime

TIMESTAMP_WITH_TIME_ZONE

java.time.OffsetDateTime

OBJECT

Any Java class
lifebuoy

Help and support