public final class OracleTemporalField extends Object
This class defines TemporalFields that are specific to Oracle Database.
The field ChronoField.YEAR represents the year as an integer where the value 0 represents 1 BCE and -1 represents 2 BCE. ChronoField.YEAR_OF_ERA represents the positive value of the year within the era. The YEAR_OF_ERA value of 1 BCE is 1. Neither corresponds to the Oracle Database representation.
Example
DateTimeFormatter f = new DateTimeFormatterBuilder()
.appendValue(OracleField.SIGNED_YEAR_OF_ERA)
.appendLiteral("-")
.appendValue(ChronoField.MONTH_OF_YEAR)
.appendLiteral("-")
.appendValue(ChronoField.DAY_OF_MONTH)
.toFormatter();
LocalDate d = f.parse(rs.getObject(i, String.class), TemporalQueries.localDate());
ps.setObject(j, f.format(d), JDBCType.VARCHAR);
Modifier and Type | Field and Description |
---|---|
static java.time.temporal.TemporalField |
SIGNED_YEAR_OF_ERA
The field that represents the signed year of the era as used by Oracle Database.
|
public static final java.time.temporal.TemporalField SIGNED_YEAR_OF_ERA
This field allows the signed year of era value to be queried and set. The signed year of era has values from Long.MAX_VALUE to Long.MIN_VALUE excluding 0.
The signed year of era can only be calculated if the year is available.
This field is an immutable and thread-safe singleton.