Top Description Fields Constructors Methods
org.h2.value

public final Class ValueTimeTimeZone

extends Value
Class Inheritance
Imports
org.h2.api.ErrorCode, org.h2.engine.CastDataProvider, org.h2.message.DbException, org.h2.util.DateTimeUtils

Implementation of the TIME WITH TIME ZONE data type.

Field Summary

Modifier and TypeField and Description
public static final int
DEFAULT_PRECISION

The default precision and display size of the textual representation of a time.

public static final int
MAXIMUM_PRECISION

The maximum precision and display size of the textual representation of a time.

private final long
nanos

Nanoseconds since midnight

private final int
timeZoneOffsetSeconds

Time zone offset from UTC in seconds, range of -18 hours to +18 hours.

Inherited from org.h2.value.Value:
ARRAYASSIGN_TOBIGINTBINARYBLOBBOOLEANCAST_TOCHARCLOBCONVERT_TODATEDECFLOATDOUBLEEMPTY_VALUESENUMGEOMETRYGROUP_BINARY_STRINGGROUP_BOOLEANGROUP_CHARACTER_STRINGGROUP_COLLECTIONGROUP_DATETIMEGROUP_INTERVAL_DTGROUP_INTERVAL_YMGROUP_NULLGROUP_NUMERICGROUP_OTHERGROUPSINTEGERINTERVAL_DAYINTERVAL_DAY_TO_HOURINTERVAL_DAY_TO_MINUTEINTERVAL_DAY_TO_SECONDINTERVAL_HOURINTERVAL_HOUR_TO_MINUTEINTERVAL_HOUR_TO_SECONDINTERVAL_MINUTEINTERVAL_MINUTE_TO_SECONDINTERVAL_MONTHINTERVAL_SECONDINTERVAL_YEARINTERVAL_YEAR_TO_MONTHJAVA_OBJECTJSONMAX_LONG_DECIMALMIN_LONG_DECIMALNULLNUMERICREALROWSMALLINTTIMETIME_TZTIMESTAMPTIMESTAMP_TZTINYINTTYPE_COUNTUNKNOWNUUIDVARBINARYVARCHARVARCHAR_IGNORECASE

Constructor Summary

AccessConstructor and Description
private
ValueTimeTimeZone(long
nanoseconds since midnight
nanos
,
int timeZoneOffsetSeconds)

Method Summary

Modifier and TypeMethod and Description
public int
compareTypeSafe(Value
the other value
o
,
CompareMode
the compare mode
mode
,
CastDataProvider
the cast information provider
provider
)

Implements abstract org.h2.value.Value.compareTypeSafe.

Compare this value against another value given that the values are of the same data type.

public boolean
equals(Object
the other value
other
)

Implements abstract org.h2.value.Value.equals.

Check if the two values have the same hash code.

public static ValueTimeTimeZone

Returns:

the value
fromNanos
(long
the nanoseconds since midnight
nanos
,
int
the timezone offset in seconds
timeZoneOffsetSeconds
)

Get or create a time value.

public int
getMemory()

Overrides org.h2.value.Value.getMemory.

Get the memory used by this object.

public long

Returns:

nanoseconds since midnight
getNanos
()

public StringBuilder
getSQL(StringBuilder
string builder
builder
,
int
formatting flags
sqlFlags
)

Implements org.h2.util.HasSQL.getSQL.

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

public String
getString()

Implements abstract org.h2.value.Value.getString.

Get the value as a string.

public int

Returns:

the offset
getTimeZoneOffsetSeconds
()

The time zone offset in seconds.

public TypeInfo
getType()

Implements abstract org.h2.value.Value.getType.

Implements org.h2.value.Typed.getType.

Returns the data type.

public int
getValueType()

Implements abstract org.h2.value.Value.getValueType.

Get the value type.

public int
hashCode()

Implements abstract org.h2.value.Value.hashCode.

Returns a hash code value for this object.

public static ValueTimeTimeZone

Returns:

the time
parse
(String
the string to parse
s
,
CastDataProvider
the cast information provider, may be null for literals with time zone
provider
)

Parse a string to a ValueTime.

private StringBuilder
Inherited from org.h2.value.Value:
addcachecastTocharLengthclearCachecompareTocompareWithNullcontainsNullconvertForAssignToconvertToconvertToconvertToconvertToconvertToconvertToAnyArrayconvertToAnyJsonconvertToAnyRowconvertToBigintconvertToBooleanconvertToCharconvertToDateconvertToDoubleconvertToEnumconvertToGeometryconvertToIntconvertToIntconvertToJavaObjectconvertToJsonconvertToLongconvertToRealconvertToSmallintconvertToTinyintconvertToUuiddividegetBigDecimalgetBooleangetBytegetBytesgetBytesNoCopygetDataConversionErrorgetDataConversionErrorgetDoublegetFloatgetHigherOrdergetHigherOrderKnowngetInputStreamgetInputStreamgetIntgetLonggetReadergetReadergetShortgetSignumgetTypeNamegetUnsupportedExceptionForOperationgetValueTooLongExceptiongetValueWithFirstNullgetValueWithFirstNullImplisFalseisTruemodulusmultiplynegateoctetLengthrangeChecksubtracttoString

Field Detail

DEFAULT_PRECISIONback to summary
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

MAXIMUM_PRECISIONback to summary
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

nanosback to summary
private final long nanos

Nanoseconds since midnight

timeZoneOffsetSecondsback to summary
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

ValueTimeTimeZoneback to summary
private ValueTimeTimeZone(long nanos, int timeZoneOffsetSeconds)
Parameters
nanos:long

nanoseconds since midnight

Method Detail

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

Implements abstract org.h2.value.Value.compareTypeSafe.

Doc from org.h2.value.Value.compareTypeSafe.

Compare this value against another value given that the values are of the same data type.

Parameters
o:Value

the other value

mode:CompareMode

the compare mode

provider:CastDataProvider

the cast information provider

Returns:int

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

Annotations
@Override
equalsback to summary
public boolean equals(Object other)

Implements abstract org.h2.value.Value.equals.

Doc from org.h2.value.Value.equals.

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.

Parameters
other:Object

the other value

Returns:boolean

true if they are equal

Annotations
@Override
fromNanosback to summary
public static ValueTimeTimeZone fromNanos(long nanos, int timeZoneOffsetSeconds)

Get or create a time value.

Parameters
nanos:long

the nanoseconds since midnight

timeZoneOffsetSeconds:int

the timezone offset in seconds

Returns:ValueTimeTimeZone

the value

getMemoryback to summary
public int getMemory()

Overrides org.h2.value.Value.getMemory.

Doc from org.h2.value.Value.getMemory.

Get the memory used by this object.

Returns:int

the memory used in bytes

Annotations
@Override
getNanosback to summary
public long getNanos()
Returns:long

nanoseconds since midnight

getSQLback to summary
public StringBuilder getSQL(StringBuilder builder, int sqlFlags)

Implements org.h2.util.HasSQL.getSQL.

Doc from org.h2.util.HasSQL.getSQL.

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

Parameters
builder:StringBuilder

string builder

sqlFlags:int

formatting flags

Returns:StringBuilder

the specified string builder

Annotations
@Override
getStringback to summary
public String getString()

Implements abstract org.h2.value.Value.getString.

Doc from org.h2.value.Value.getString.

Get the value as a string.

Returns:String

the string

Annotations
@Override
getTimeZoneOffsetSecondsback to summary
public int getTimeZoneOffsetSeconds()

The time zone offset in seconds.

Returns:int

the offset

getTypeback to summary
public TypeInfo getType()

Implements abstract org.h2.value.Value.getType.

Implements org.h2.value.Typed.getType.

Doc from org.h2.value.Typed.getType.

Returns the data type.

Returns:TypeInfo

the data type

Annotations
@Override
getValueTypeback to summary
public int getValueType()

Implements abstract org.h2.value.Value.getValueType.

Doc from org.h2.value.Value.getValueType.

Get the value type.

Returns:int

the value type

Annotations
@Override
hashCodeback to summary
public int hashCode()

Implements abstract org.h2.value.Value.hashCode.

Doc from java.lang.Object.hashCode.

Returns a hash code value for this object. This method is supported for the benefit of hash tables such as those provided by java.util.HashMap.

The general contract of hashCode is:

  • Whenever it is invoked on the same object more than once during an execution of a Java application, the hashCode method must consistently return the same integer, provided no information used in equals comparisons on the object is modified. This integer need not remain consistent from one execution of an application to another execution of the same application.
  • If two objects are equal according to the equals method, then calling the hashCode method on each of the two objects must produce the same integer result.
  • It is not required that if two objects are unequal according to the equals method, then calling the hashCode method on each of the two objects must produce distinct integer results. However, the programmer should be aware that producing distinct integer results for unequal objects may improve the performance of hash tables.
Returns:int

a hash code value for this object

Annotations
@Override
parseback to summary
public static ValueTimeTimeZone parse(String s, CastDataProvider provider)

Parse a string to a ValueTime.

Parameters
s:String

the string to parse

provider:CastDataProvider

the cast information provider, may be null for literals with time zone

Returns:ValueTimeTimeZone

the time

toStringback to summary
private StringBuilder toString(StringBuilder builder)