H2 Database Engine 2.3.232 · org.h2.value.ValueTimestamp

Modifier and Type	Field and Description
private final long	dateValue A bit field with bits for the year, month, and day (see DateTimeUtils for encoding)
public static final int	DEFAULT_PRECISION The default precision and display size of the textual representation of a timestamp.
public static final int	DEFAULT_SCALE The default scale for timestamps.
public static final int	MAXIMUM_PRECISION The maximum precision and display size of the textual representation of a timestamp.
public static final int	MAXIMUM_SCALE The maximum scale for timestamps.
private final long	timeNanos The nanoseconds since midnight.

Access	Constructor and Description
private	ValueTimestamp(long dateValue, long timeNanos)

Method Summary

Modifier and Type	Method and Description
public Value	add(Value the value to add v) Overrides org.h2.value.Value.add. Add a value and return the result.
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 ValueTimestamp	Returns: the value fromDateValueAndNanos(long the date value, a bit field with bits for the year, month, and day dateValue, long the nanoseconds since midnight timeNanos) Get or create a date value for the given date.
public long	Returns: the data value getDateValue() A bit field with bits for the year, month, and day (see DateTimeUtils for encoding).
public String	Returns: value as string in ISO format getISOString() Returns value as string in ISO format.
public int	getMemory() Overrides org.h2.value.Value.getMemory. Get the memory used by this object.
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 long	Returns: the nanoseconds getTimeNanos() The nanoseconds since midnight.
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 ValueTimestamp	Returns: the date parse(String the string to parse s, CastDataProvider the cast information provider, may be `null` for literals without time zone provider) Parse a string to a ValueTimestamp, using the given `CastDataProvider`.
public Value	subtract(Value the value to subtract v) Overrides org.h2.value.Value.subtract. Subtract a value and return the result.
private StringBuilder	toString(StringBuilder builder, boolean iso)

Inherited from org.h2.value.Value:: cache castTo charLength clearCache compareTo compareWithNull containsNull convertForAssignTo convertTo convertTo convertTo convertTo convertTo convertToAnyArray convertToAnyJson convertToAnyRow convertToBigint convertToBoolean convertToChar convertToDate convertToDouble convertToEnum convertToGeometry convertToInt convertToInt convertToJavaObject convertToJson convertToLong 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 getValueWithFirstNull getValueWithFirstNullImpl isFalse isTrue modulus multiply negate octetLength rangeCheck toString

dateValue	back to summary
private final long dateValue A bit field with bits for the year, month, and day (see DateTimeUtils for encoding)

DEFAULT_PRECISION	back to summary
public static final int DEFAULT_PRECISION The default precision and display size of the textual representation of a timestamp. Example: 2001-01-01 23:59:59.123456

DEFAULT_SCALE	back to summary
public static final int DEFAULT_SCALE The default scale for timestamps.

MAXIMUM_PRECISION	back to summary
public static final int MAXIMUM_PRECISION The maximum precision and display size of the textual representation of a timestamp. Example: 2001-01-01 23:59:59.123456789

MAXIMUM_SCALE	back to summary
public static final int MAXIMUM_SCALE The maximum scale for timestamps.

timeNanos	back to summary
private final long timeNanos The nanoseconds since midnight.

ValueTimestamp	back to summary
private ValueTimestamp(long dateValue, long timeNanos)

Method Detail

add	back to summary
public Value add(Value v) Overrides org.h2.value.Value.add. Doc from org.h2.value.Value.add. Add a value and return the result. Parameters v:Value the value to add Returns:Value the result Annotations @Override

add

back to summary

public Value add(Value v)

Overrides org.h2.value.Value.add.

Doc from org.h2.value.Value.add.

Add a value and return the result.

Parameters

v:Value: the value to add

Returns:Value

the result

Annotations

@Override

compareTypeSafe	back 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

compareTypeSafe

back 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

equals	back 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

equals

back 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

fromDateValueAndNanos	back to summary
public static ValueTimestamp fromDateValueAndNanos(long dateValue, long timeNanos) Get or create a date value for the given date. Parameters dateValue:long the date value, a bit field with bits for the year, month, and day timeNanos:long the nanoseconds since midnight Returns:ValueTimestamp the value

fromDateValueAndNanos

back to summary

public static ValueTimestamp fromDateValueAndNanos(long dateValue, long timeNanos)

Get or create a date value for the given date.

Parameters

dateValue:long: the date value, a bit field with bits for the year, month, and day
timeNanos:long: the nanoseconds since midnight

Returns:ValueTimestamp

the value

getDateValue	back to summary
public long getDateValue() A bit field with bits for the year, month, and day (see DateTimeUtils for encoding). Returns:long the data value

getDateValue

back to summary

public long getDateValue()

A bit field with bits for the year, month, and day (see DateTimeUtils for encoding).

Returns:long: the data value

getISOString	back to summary
public String getISOString() Returns value as string in ISO format. Returns:String value as string in ISO format

getISOString

back to summary

public String getISOString()

Returns value as string in ISO format.

Returns:String: value as string in ISO format

getMemory	back 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

getMemory

back 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

getSQL	back 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

getSQL

back 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

getString	back 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

getString

back 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

getTimeNanos	back to summary
public long getTimeNanos() The nanoseconds since midnight. Returns:long the nanoseconds

getTimeNanos

back to summary

public long getTimeNanos()

The nanoseconds since midnight.

Returns:long: the nanoseconds

getType	back 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

getType

back 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

getValueType	back 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

getValueType

back 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

hashCode back to summary

hashCode	back 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

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

parse back to summary

parse	back to summary
public static ValueTimestamp parse(String s, CastDataProvider provider) Parse a string to a ValueTimestamp, using the given `CastDataProvider`. This method supports the format +/-year-month-day[ -]hour[:.]minute[:.]seconds.fractional and an optional timezone part. Parameters s:String the string to parse provider:CastDataProvider the cast information provider, may be `null` for literals without time zone Returns:ValueTimestamp the date

public static ValueTimestamp parse(String s, CastDataProvider provider)

Parse a string to a ValueTimestamp, using the given CastDataProvider. This method supports the format +/-year-month-day[ -]hour[:.]minute[:.]seconds.fractional and an optional timezone part.

Parameters

s:String: the string to parse
provider:CastDataProvider: the cast information provider, may be null for literals without time zone

Returns:ValueTimestamp

the date

subtract	back to summary
public Value subtract(Value v) Overrides org.h2.value.Value.subtract. Doc from org.h2.value.Value.subtract. Subtract a value and return the result. Parameters v:Value the value to subtract Returns:Value the result Annotations @Override

subtract

back to summary

public Value subtract(Value v)

Overrides org.h2.value.Value.subtract.

Doc from org.h2.value.Value.subtract.

Subtract a value and return the result.

Parameters