Date
java.sql.Date
java.time.LocalDate
org.joda.time.DateMidnight
org.joda.time.LocalDate
DateTime
java.sql.Timestamp
java.time.Instant
java.time.LocalDateTime
java.time.OffsetDateTime
java.time.ZonedDateTime
java.util.Date
java.util.Calendar
org.joda.time.DateTime
org.joda.time.LocalDateTime
Time
java.sql.Time
java.time.LocalTime
org.joda.time.LocalTime
org.joda.time.LocalTimeUTC
Time related types
| Type | Default mapping |
|---|---|
| java.time.Year | INTEGER |
| java.time.YearMonth | DATE (with Day of month = 1) |
| java.time.MonthDay | DATE (with Year = 2000) |
| java.time.Duration | Decimal |
| java.time.Period | Varchar(20) |
| java.time.ZoneOffset | Varchar(60) |
| java.time.OffsetTime | Varchar(25) |
| java.time.ZoneId | Varchar(60) |
| java.time.TimeZone | Varchar(20) |
| org.joda.time.Period | Varchar(50) |