Package org.h2.value
Class ValueTimestampTimeZone
Implementation of the TIMESTAMP WITH TIME ZONE data type.
-
Field Summary
FieldsModifier and TypeFieldDescriptionprivate final long
A bit field with bits for the year, month, and day (see DateTimeUtils for encoding)static final int
The default precision and display size of the textual representation of a timestamp.static final int
The maximum precision and display size of the textual representation of a timestamp.private final long
The nanoseconds since midnight.private final int
Time zone offset from UTC in seconds, range of -18 hours to +18 hours.Fields inherited from class org.h2.value.Value
ARRAY, ASSIGN_TO, BIGINT, BINARY, BLOB, BOOLEAN, CAST_TO, CHAR, CLOB, CONVERT_TO, DATE, DECFLOAT, DOUBLE, EMPTY_VALUES, ENUM, GEOMETRY, GROUP_BINARY_STRING, GROUP_BOOLEAN, GROUP_CHARACTER_STRING, GROUP_COLLECTION, GROUP_DATETIME, GROUP_INTERVAL_DT, GROUP_INTERVAL_YM, GROUP_NULL, GROUP_NUMERIC, GROUP_OTHER, GROUPS, INTEGER, INTERVAL_DAY, INTERVAL_DAY_TO_HOUR, INTERVAL_DAY_TO_MINUTE, INTERVAL_DAY_TO_SECOND, INTERVAL_HOUR, INTERVAL_HOUR_TO_MINUTE, INTERVAL_HOUR_TO_SECOND, INTERVAL_MINUTE, INTERVAL_MINUTE_TO_SECOND, INTERVAL_MONTH, INTERVAL_SECOND, INTERVAL_YEAR, INTERVAL_YEAR_TO_MONTH, JAVA_OBJECT, JSON, MAX_LONG_DECIMAL, MIN_LONG_DECIMAL, NULL, NUMERIC, REAL, ROW, SMALLINT, TIME, TIME_TZ, TIMESTAMP, TIMESTAMP_TZ, TINYINT, TYPE_COUNT, UNKNOWN, UUID, VARBINARY, VARCHAR, VARCHAR_IGNORECASE
Fields inherited from interface org.h2.util.HasSQL
ADD_PLAN_INFORMATION, DEFAULT_SQL_FLAGS, NO_CASTS, QUOTE_ONLY_WHEN_REQUIRED, REPLACE_LOBS_FOR_TRACE, TRACE_SQL_FLAGS
-
Constructor Summary
ConstructorsModifierConstructorDescriptionprivate
ValueTimestampTimeZone
(long dateValue, long timeNanos, int timeZoneOffsetSeconds) -
Method Summary
Modifier and TypeMethodDescriptionint
compareTypeSafe
(Value o, CompareMode mode, CastDataProvider provider) Compare this value against another value given that the values are of the same data type.boolean
Check if the two values have the same hash code.static ValueTimestampTimeZone
fromDateValueAndNanos
(long dateValue, long timeNanos, int timeZoneOffsetSeconds) Get or create a date value for the given date.long
A bit field with bits for the year, month, and day (see DateTimeUtils for encoding).Returns value as string in ISO format.int
Get the memory used by this object.getSQL
(StringBuilder builder, int sqlFlags) Appends the SQL statement of this object to the specified builder.Get the value as a string.long
The nanoseconds since midnight.int
The time zone offset in seconds.getType()
Returns the data type.int
Get the value type.int
hashCode()
static ValueTimestampTimeZone
parse
(String s, CastDataProvider provider) Parse a string to a ValueTimestamp.private StringBuilder
toString
(StringBuilder builder, boolean iso) Methods inherited from class org.h2.value.Value
add, cache, castTo, charLength, clearCache, compareTo, compareWithNull, containsNull, convertForAssignTo, convertTo, convertTo, convertTo, convertTo, convertTo, convertToAnyArray, convertToAnyRow, convertToBigint, convertToBoolean, convertToChar, convertToDate, convertToDouble, convertToEnum, convertToGeometry, convertToInt, convertToInt, convertToJavaObject, convertToReal, convertToSmallint, convertToTinyint, convertToUuid, divide, getBigDecimal, getBoolean, getByte, getBytes, getBytesNoCopy, getDataConversionError, getDataConversionError, getDouble, getFloat, getHigherOrder, getHigherOrderKnown, getInputStream, getInputStream, getInt, getLong, getReader, getReader, getShort, getSignum, getTypeName, getUnsupportedExceptionForOperation, getValueTooLongException, isFalse, isTrue, modulus, multiply, negate, octetLength, rangeCheck, subtract, toString
Methods inherited from class org.h2.value.VersionedValue
getCommittedValue, getCurrentValue, getOperationId, isCommitted
Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait
Methods inherited from interface org.h2.util.HasSQL
getSQL, getTraceSQL
-
Field Details
-
DEFAULT_PRECISION
public static final int DEFAULT_PRECISIONThe default precision and display size of the textual representation of a timestamp. Example: 2001-01-01 23:59:59.123456+10:00- See Also:
-
MAXIMUM_PRECISION
public static final int MAXIMUM_PRECISIONThe maximum precision and display size of the textual representation of a timestamp. Example: 2001-01-01 23:59:59.123456789+10:00- See Also:
-
dateValue
private final long dateValueA bit field with bits for the year, month, and day (see DateTimeUtils for encoding) -
timeNanos
private final long timeNanosThe nanoseconds since midnight. -
timeZoneOffsetSeconds
private final int timeZoneOffsetSecondsTime zone offset from UTC in seconds, range of -18 hours to +18 hours. This range is compatible with OffsetDateTime from JSR-310.
-
-
Constructor Details
-
ValueTimestampTimeZone
private ValueTimestampTimeZone(long dateValue, long timeNanos, int timeZoneOffsetSeconds)
-
-
Method Details
-
fromDateValueAndNanos
public static ValueTimestampTimeZone fromDateValueAndNanos(long dateValue, long timeNanos, int timeZoneOffsetSeconds) Get or create a date value for the given date.- Parameters:
dateValue
- the date value, a bit field with bits for the year, month, and daytimeNanos
- the nanoseconds since midnighttimeZoneOffsetSeconds
- the timezone offset in seconds- Returns:
- the value
-
parse
Parse a string to a ValueTimestamp. This method supports the format +/-year-month-day hour:minute:seconds.fractional and an optional timezone part.- Parameters:
s
- the string to parseprovider
- the cast information provider, may benull
for literals with time zone- Returns:
- the date
-
getDateValue
public long getDateValue()A bit field with bits for the year, month, and day (see DateTimeUtils for encoding).- Returns:
- the data value
-
getTimeNanos
public long getTimeNanos()The nanoseconds since midnight.- Returns:
- the nanoseconds
-
getTimeZoneOffsetSeconds
public int getTimeZoneOffsetSeconds()The time zone offset in seconds.- Returns:
- the offset
-
getType
Description copied from interface:Typed
Returns the data type. -
getValueType
public int getValueType()Description copied from class:Value
Get the value type.- Specified by:
getValueType
in classValue
- Returns:
- the value type
-
getMemory
public int getMemory()Description copied from class:Value
Get the memory used by this object. -
getString
Description copied from class:Value
Get the value as a string. -
getISOString
Returns value as string in ISO format.- Returns:
- value as string in ISO format
-
getSQL
Description copied from interface:HasSQL
Appends the SQL statement of this object to the specified builder.- Parameters:
builder
- string buildersqlFlags
- formatting flags- Returns:
- the specified string builder
-
toString
-
compareTypeSafe
Description copied from class:Value
Compare this value against another value given that the values are of the same data type.- Specified by:
compareTypeSafe
in classValue
- Parameters:
o
- the other valuemode
- the compare modeprovider
- the cast information provider- Returns:
- 0 if both values are equal, -1 if the other value is smaller, and 1 otherwise
-
equals
Description copied from class:Value
Check if the two values have the same hash code. No data conversion is made; this method returns false if the other object is not of the same class. For some values, compareTo may return 0 even if equals return false. Example: ValueDecimal 0.0 and 0.00. -
hashCode
public int hashCode()
-