Package org.h2.value

Class ValueTimeTimeZone

java.lang.Object

org.h2.value.VersionedValue<Value>

org.h2.value.Value

org.h2.value.ValueTimeTimeZone

All Implemented Interfaces:

HasSQL, Typed

public final class ValueTimeTimeZone
extends Value

Implementation of the TIME WITH TIME ZONE data type.

Field Summary

Fields

Modifier and Type	Field	Description
static int	DEFAULT_PRECISION	The default precision and display size of the textual representation of a time.
static int	MAXIMUM_PRECISION	The maximum precision and display size of the textual representation of a time.
private long	nanos	Nanoseconds since midnight
private int	timeZoneOffsetSeconds	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

Constructors

Modifier	Constructor	Description
private	ValueTimeTimeZone(long nanos, int timeZoneOffsetSeconds)

Method Summary

Modifier and Type	Method	Description
int	compareTypeSafe(Value o, CompareMode mode, CastDataProvider provider)	Compare this value against another value given that the values are of the same data type.
boolean	equals(java.lang.Object other)	Check if the two values have the same hash code.
static ValueTimeTimeZone	fromNanos(long nanos, int timeZoneOffsetSeconds)	Get or create a time value.
int	getMemory()	Get the memory used by this object.
long	getNanos()
java.lang.StringBuilder	getSQL(java.lang.StringBuilder builder, int sqlFlags)	Appends the SQL statement of this object to the specified builder.
java.lang.String	getString()	Get the value as a string.
int	getTimeZoneOffsetSeconds()	The time zone offset in seconds.
TypeInfo	getType()	Returns the data type.
int	getValueType()	Get the value type.
int	hashCode()
static ValueTimeTimeZone	parse(java.lang.String s)	Parse a string to a ValueTime.
private java.lang.StringBuilder	toString(java.lang.StringBuilder builder)

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 Detail

DEFAULT_PRECISION

public static final int DEFAULT_PRECISION

The default precision and display size of the textual representation of a time. Example: 10:00:00+10:00

See Also:

Constant Field Values

MAXIMUM_PRECISION

public static final int MAXIMUM_PRECISION

The maximum precision and display size of the textual representation of a time. Example: 10:00:00.123456789+10:00

See Also:

Constant Field Values

nanos

private final long nanos

Nanoseconds since midnight

timeZoneOffsetSeconds

private final int timeZoneOffsetSeconds

Time zone offset from UTC in seconds, range of -18 hours to +18 hours. This range is compatible with OffsetTime from JSR-310.

Constructor Detail

ValueTimeTimeZone

private ValueTimeTimeZone(long nanos,
                          int timeZoneOffsetSeconds)

Parameters:

nanos - nanoseconds since midnight

Method Detail

fromNanos

public static ValueTimeTimeZone fromNanos(long nanos,
                                          int timeZoneOffsetSeconds)

Get or create a time value.

Parameters:

nanos - the nanoseconds since midnight

timeZoneOffsetSeconds - the timezone offset in seconds

Returns:

the value

parse

public static ValueTimeTimeZone parse(java.lang.String s)

Parse a string to a ValueTime.

Parameters:

s - the string to parse

Returns:

the time

getNanos

public long getNanos()

Returns:

nanoseconds since midnight

getTimeZoneOffsetSeconds

public int getTimeZoneOffsetSeconds()

The time zone offset in seconds.

Returns:

the offset

getType

public TypeInfo getType()

Description copied from interface: Typed

Returns the data type.

Specified by:

getType in interface Typed

Specified by:

getType in class Value

Returns:

the data type

getValueType

public int getValueType()

Description copied from class: Value

Get the value type.

Specified by:

getValueType in class Value

Returns:

the value type

getMemory

public int getMemory()

Description copied from class: Value

Get the memory used by this object.

Overrides:

getMemory in class Value

Returns:

the memory used in bytes

getString

public java.lang.String getString()

Description copied from class: Value

Get the value as a string.

Specified by:

getString in class Value

Returns:

the string

getSQL

public java.lang.StringBuilder getSQL(java.lang.StringBuilder builder,
                                      int sqlFlags)

Description copied from interface: HasSQL

Appends the SQL statement of this object to the specified builder.

Parameters:

builder - string builder

sqlFlags - formatting flags

Returns:

the specified string builder

toString

private java.lang.StringBuilder toString(java.lang.StringBuilder builder)

compareTypeSafe

public int compareTypeSafe(Value o,
                           CompareMode mode,
                           CastDataProvider provider)

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 class Value

Parameters:

o - the other value

mode - the compare mode

provider - the cast information provider

Returns:

0 if both values are equal, -1 if the other value is smaller, and 1 otherwise

equals

public boolean equals(java.lang.Object other)

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.

Specified by:

equals in class Value

Parameters:

other - the other value

Returns:

true if they are equal

hashCode

public int hashCode()

Specified by:

hashCode in class Value