Package org.h2.value
Class ValueTimestamp
- java.lang.Object
-
- org.h2.value.VersionedValue<Value>
-
- org.h2.value.Value
-
- org.h2.value.ValueTimestamp
-
-
Field Summary
Fields Modifier and Type Field Description private long
dateValue
A bit field with bits for the year, month, and day (see DateTimeUtils for encoding)static int
DEFAULT_PRECISION
The default precision and display size of the textual representation of a timestamp.static int
DEFAULT_SCALE
The default scale for timestamps.static int
MAXIMUM_PRECISION
The maximum precision and display size of the textual representation of a timestamp.static int
MAXIMUM_SCALE
The maximum scale for timestamps.private long
timeNanos
The nanoseconds since midnight.-
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
ValueTimestamp(long dateValue, long timeNanos)
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description Value
add(Value v)
Add a value and return the result.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 ValueTimestamp
fromDateValueAndNanos(long dateValue, long timeNanos)
Get or create a date value for the given date.long
getDateValue()
A bit field with bits for the year, month, and day (see DateTimeUtils for encoding).java.lang.String
getISOString()
Returns value as string in ISO format.int
getMemory()
Get the memory used by this object.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.long
getTimeNanos()
The nanoseconds since midnight.TypeInfo
getType()
Returns the data type.int
getValueType()
Get the value type.int
hashCode()
static ValueTimestamp
parse(java.lang.String s, CastDataProvider provider)
Parse a string to a ValueTimestamp, using the givenCastDataProvider
.Value
subtract(Value v)
Subtract a value and return the result.private java.lang.StringBuilder
toString(java.lang.StringBuilder builder, boolean iso)
-
Methods inherited from class org.h2.value.Value
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, 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 timestamp. Example: 2001-01-01 23:59:59.123456- 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 timestamp. Example: 2001-01-01 23:59:59.123456789- See Also:
- Constant Field Values
-
DEFAULT_SCALE
public static final int DEFAULT_SCALE
The default scale for timestamps.- See Also:
- Constant Field Values
-
MAXIMUM_SCALE
public static final int MAXIMUM_SCALE
The maximum scale for timestamps.- See Also:
- Constant Field Values
-
dateValue
private final long dateValue
A bit field with bits for the year, month, and day (see DateTimeUtils for encoding)
-
timeNanos
private final long timeNanos
The nanoseconds since midnight.
-
-
Method Detail
-
fromDateValueAndNanos
public static ValueTimestamp fromDateValueAndNanos(long dateValue, long timeNanos)
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 midnight- Returns:
- the value
-
parse
public static ValueTimestamp parse(java.lang.String s, CastDataProvider provider)
Parse a string to a ValueTimestamp, using the givenCastDataProvider
. 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 without 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
-
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
public java.lang.String getString()
Description copied from class:Value
Get the value as a string.
-
getISOString
public java.lang.String getISOString()
Returns value as string in ISO format.- Returns:
- value as string in ISO format
-
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 buildersqlFlags
- formatting flags- Returns:
- the specified string builder
-
toString
private java.lang.StringBuilder toString(java.lang.StringBuilder builder, boolean iso)
-
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 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
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.
-
add
public Value add(Value v)
Description copied from class:Value
Add a value and return the result.
-
-