SQL Type | Scala Type |
|---|---|
BOOLEAN | Boolean |
INTEGER1 | Byte |
SMALLINT | Short |
INTEGER | Int |
BIGINT | Long |
FLOAT4 | Float |
FLOAT | Double |
MONEY | Double |
DECIMAL | java.math.BigDecimal |
CHAR | String |
VARCHAR | String |
NVARCHAR | String |
ANSIDATE | java.sql.date |
TIME WITHOUT TIMEZONE | java.sql.Timestamp |
TIME WITH LOCAL TIMEZONE | java.sql.Timestamp |
TIME WITH TIMEZONE | java.sql.Timestamp |
TIMESTAMP WITHOUT TIMEZONE | java.sql.Timestamp |
TIMESTAMP WITH LOCAL TIMEZONE | java.sql.Timestamp |
TIMESTAMP WITH TIMEZONE | java.sql.Timestamp |
INTERVAL YEAR TO MONTH | String (“<num of years>-<num of month>“ |
INTERVAL DAY TO SECOND | String (“<num of days> <hours>:<minutes>:<seconds>“) |
IPv4 | String |
IPv6 | String |
UUID | String |
BYTE VARBYTE | Array[Byte] |
In case of user defined NULL handling, all parameters as well as the return value are wrapped as Scala option. | |