Hint
This article is generated by AI translation.
Date/time type handlers
Handlers are in net.hasor.dbvisitor.types.handler.time.
Common handlers
| Handler | Java type | Purpose |
|---|---|---|
| LocalDateTimeTypeHandler | java.time.LocalDateTime | getObject/setObject for LocalDateTime |
| LocalTimeTypeHandler | java.time.LocalTime | getObject/setObject for LocalTime |
| OffsetDateTimeTypeHandler | java.time.OffsetDateTime | getObject/setObject for OffsetDateTime |
| OffsetTimeTypeHandler | java.time.OffsetTime | getObject/setObject for OffsetTime |
| SqlDateTypeHandler | java.sql.Date | getObject/setObject for Date |
| SqlTimestampTypeHandler | java.sql.Timestamp | getObject/setObject for Timestamp |
| SqlTimeTypeHandler | java.sql.Time | getObject/setObject for Time |
Using java.util.Date
| Handler | Java type | Purpose |
|---|---|---|
| SqlDateAsDateHandler | java.util.Date | getDate/setDate; uses only the date portion |
| SqlTimeAsDateTypeHandler | java.util.Date | getTime/setTime; drops the date portion |
| SqlTimestampAsDateTypeHandler | java.util.Date | getTimestamp/setTimestamp |
Using java.time.Year
| Handler | Java type | Purpose |
|---|---|---|
| IntegerAsYearTypeHandler | java.time.Year | Read/write a numeric year |
| StringAsYearTypeHandler | java.time.Year | Read/write a numeric year from a string |
| SqlTimestampAsYearTypeHandler | java.time.Year | getTimestamp/setTimestamp; drops month/day/time |
Using java.time.YearMonth
| Handler | Java type | Purpose |
|---|---|---|
| IntegerAsYearMonthTypeHandler | java.time.YearMonth | Numeric: last 2 digits are month, the rest is year; 0 -> 0000-01 |
| StringAsYearMonthTypeHandler | java.time.YearMonth | String format "yyyy-MM" |
| SqlTimestampAsYearMonthTypeHandler | java.time.YearMonth | getTimestamp/setTimestamp; drops day/time |
Using java.time.Month
| Handler | Java type | Purpose |
|---|---|---|
| IntegerAsMonthTypeHandler | java.time.Month | Numeric month 1-12 |
| StringAsMonthTypeHandler | java.time.Month | String month 1-12 |
| SqlTimestampAsMonthTypeHandler | java.time.Month | getTimestamp/setTimestamp; drops year/day/time |
Using java.time.MonthDay
| Handler | Java type | Purpose |
|---|---|---|
| IntegerAsMonthDayTypeHandler | java.time.MonthDay | Four digits: MMDD |
| StringAsMonthDayTypeHandler | java.time.MonthDay | String format "MM-dd" |
| SqlTimestampAsMonthDayTypeHandler | java.time.MonthDay | getTimestamp/setTimestamp; drops year/time |
Type conversions
| Handler | Java type | Purpose |
|---|---|---|
| SqlDateAsDateHandler | java.util.Date | getDate/setDate |
| SqlTimeAsDateTypeHandler | java.util.Date | getTime/setTime; drops the date part |
| SqlTimestampAsDateTypeHandler | java.util.Date | getTimestamp/setTimestamp |
| SqlTimestampAsLocalDateTimeTypeHandler | java.time.LocalDateTime | getTimestamp/setTimestamp |
| SqlTimestampAsLocalDateTypeHandler | java.time.LocalDate | getTimestamp/setTimestamp; missing time filled with 00:00 |
| SqlTimestampAsLocalTimeTypeHandler | java.time.LocalTime | getTimestamp/setTimestamp; missing date filled with 0000-01-01 |
| LocalDateTimeAsLocalTimeTypeHandler | java.time.LocalTime | getObject/setObject; converts LocalDateTime to LocalTime, missing date filled with 0000-01-01 |
| JapaneseDateAsSqlDateTypeHandler | java.time.chrono.JapaneseDate | getDate/setDate |
| LocalDateTimeAsLocalDateTypeHandler | java.time.LocalDate | getObject/setObject; converts LocalDateTime to LocalDate, missing time filled with 00:00 |
| OffsetDateTimeAsZonedDateTimeTypeHandler | java.time.ZonedDateTime | getObject/setObject; converts between OffsetDateTime and ZonedDateTime |
| SqlTimestampAsInstantTypeHandler | java.time.Instant | getTimestamp/setTimestamp |
Automatic timezone conversion
Automatically converts to UTC on read/write.
| Handler | Java type | Purpose |
|---|---|---|
| SqlTimestampAsUTCOffsetDateTimeTypeHandler | java.time.OffsetDateTime | Auto timezone conversion using OffsetDateTime |
| SqlTimestampAsUTCOffsetTimeTypeHandler | java.time.OffsetTime | Auto timezone conversion using OffsetTime |