org.hsqldb.types

Class IntervalType

java.lang.Object

org.hsqldb.types.Type

org.hsqldb.types.DTIType

org.hsqldb.types.IntervalType

All Implemented Interfaces:

java.lang.Cloneable, SchemaObject

public final class IntervalType
extends DTIType

Type subclass for various typs of INTERVAL.

Since:

1.9.0

Nested Class Summary

Nested classes/interfaces inherited from class org.hsqldb.types.Type

Type.TypedComparator

Nested classes/interfaces inherited from interface org.hsqldb.SchemaObject

SchemaObject.ConstraintTypes, SchemaObject.Deferable, SchemaObject.Nullability, SchemaObject.ParameterModes, SchemaObject.ReferentialAction, SchemaObject.ViewCheckModes

Field Summary

Fields

Modifier and Type	Field and Description
boolean	defaultPrecision
static NumberType	factorType
boolean	isYearMonth

Fields inherited from class org.hsqldb.types.DTIType

DAY_NAME, DAY_OF_MONTH, DAY_OF_WEEK, DAY_OF_YEAR, defaultIntervalFractionPrecision, defaultIntervalPrecision, defaultTimeFractionPrecision, defaultTimestampFractionPrecision, endIntervalType, endPartIndex, INTERVAL_FRACTION_PART_INDEX, INTERVAL_MONTH_INDEX, INTERVAL_SECOND_INDEX, ISO_YEAR, limitNanoseconds, maxFractionPrecision, maxIntervalPrecision, maxIntervalSecondPrecision, MONTH_NAME, nanoScaleFactors, precisionFactors, precisionLimits, QUARTER, SECONDS_MIDNIGHT, startIntervalType, startPartIndex, TIMEZONE_HOUR, TIMEZONE_MINUTE, timezoneSecondsLimit, WEEK_OF_YEAR, yearToSecondFactors, yearToSecondLimits, yearToSecondSeparators

Fields inherited from class org.hsqldb.types.Type

emptyArray, jdbcConvertTypes, OTHER, precision, scale, SQL_ALL_TYPES, SQL_ARRAY_ALL_TYPES, SQL_BIGINT, SQL_BINARY, SQL_BINARY_16, SQL_BINARY_DEFAULT, SQL_BIT, SQL_BIT_VARYING, SQL_BIT_VARYING_MAX_LENGTH, SQL_BLOB, SQL_BOOLEAN, SQL_CHAR, SQL_CHAR_16, SQL_CHAR_DEFAULT, SQL_CLOB, SQL_DATE, SQL_DECIMAL, SQL_DECIMAL_BIGINT_SQR, SQL_DECIMAL_DEFAULT, SQL_DOUBLE, SQL_INTEGER, SQL_INTERVAL_DAY, SQL_INTERVAL_DAY_MAX_PRECISION, SQL_INTERVAL_DAY_TO_HOUR, SQL_INTERVAL_DAY_TO_MINUTE, SQL_INTERVAL_DAY_TO_SECOND, SQL_INTERVAL_DAY_TO_SECOND_MAX_PRECISION, SQL_INTERVAL_HOUR, SQL_INTERVAL_HOUR_MAX_PRECISION, SQL_INTERVAL_HOUR_TO_MINUTE, SQL_INTERVAL_HOUR_TO_SECOND, SQL_INTERVAL_MINUTE, SQL_INTERVAL_MINUTE_MAX_PRECISION, SQL_INTERVAL_MINUTE_TO_SECOND, SQL_INTERVAL_MONTH, SQL_INTERVAL_MONTH_MAX_PRECISION, SQL_INTERVAL_SECOND, SQL_INTERVAL_SECOND_MAX_FRACTION, SQL_INTERVAL_SECOND_MAX_FRACTION_MAX_PRECISION, SQL_INTERVAL_SECOND_MAX_PRECISION, SQL_INTERVAL_YEAR, SQL_INTERVAL_YEAR_MAX_PRECISION, SQL_INTERVAL_YEAR_TO_MONTH, SQL_INTERVAL_YEAR_TO_MONTH_MAX_PRECISION, SQL_NUMERIC, SQL_SMALLINT, SQL_TIME, SQL_TIME_WITH_TIME_ZONE, SQL_TIMESTAMP, SQL_TIMESTAMP_NO_FRACTION, SQL_TIMESTAMP_WITH_TIME_ZONE, SQL_VARBINARY, SQL_VARBINARY_DEFAULT, SQL_VARCHAR, SQL_VARCHAR_DEFAULT, TINYINT, typeAliases, typeCode, typeComparisonGroup, typeDataGroup, typeNames, userTypeModifier

Fields inherited from interface org.hsqldb.SchemaObject

ASSERTION, CATALOG, CHARSET, COLLATION, COLUMN, CONSTRAINT, CURSOR, DOMAIN, FUNCTION, GRANTEE, INDEX, LABEL, PARAMETER, PROCEDURE, ROUTINE, SCHEMA, SEARCH, SEQUENCE, SERVER, SPECIFIC_ROUTINE, SUBQUERY, TABLE, TRANSITION, TRIGGER, TYPE, VARIABLE, VIEW, WRAPPER

Method Summary

Modifier and Type	Method and Description
java.lang.Object	absolute(java.lang.Object a) All arithmetic ops are called on the pre-determined Type object of the result
boolean	acceptsFractionalPrecision()
boolean	acceptsPrecision()
java.lang.Object	add(Session session, java.lang.Object a, java.lang.Object b, Type otherType)
boolean	canConvertFrom(Type otherType)
int	canMoveFrom(Type otherType) Can convert without changing the object
int	compare(Session session, java.lang.Object a, java.lang.Object b)
int	compareToTypeRange(java.lang.Object o)
java.lang.Object	convertJavaToSQL(SessionInterface session, java.lang.Object a)
java.lang.Object	convertToDefaultType(SessionInterface session, java.lang.Object a) Converts the object to the given type without limit checks.
double	convertToDoubleStartUnits(java.lang.Object interval)
long	convertToLongEndUnits(java.lang.Object interval)
java.lang.String	convertToSQLString(java.lang.Object a)
java.lang.String	convertToString(java.lang.Object a)
java.lang.Object	convertToType(SessionInterface session, java.lang.Object a, Type otherType) Same as castToType except for CHARACTER values.
java.lang.Object	convertToTypeLimits(SessionInterface session, java.lang.Object a)
int	displaySize()
java.lang.Object	divide(Session session, java.lang.Object a, java.lang.Object b)
Type	getAggregateType(Type other) Common type used in comparison opertions.
CharacterType	getCharacterType()
static Type	getCombinedIntervalType(IntervalType type1, IntervalType type2)
static int	getCombinedIntervalType(int startType, int endType)
Type	getCombinedType(Session session, Type other, int operation) Result type of combining values of two types in different opertions.
java.lang.String	getDefinition() Returns the full definition of the type, including parameters
int	getEndIntervalType()
static int	getEndIntervalType(int type)
static IntervalType	getIntervalType(IntervalType type, long precision, int fractionalPrecision)
static IntervalType	getIntervalType(int type, int startType, int endType, long precision, int fractionPrecision, boolean defaultPrecision)
static IntervalType	getIntervalType(int startIndex, int endIndex, long precision, int fractionPrecision)
static IntervalType	getIntervalType(int type, long precision, int fractionPrecision)
static int	getIntervalType(java.lang.String part)
java.lang.Class	getJDBCClass()
java.lang.String	getJDBCClassName() Returns the JDBC class name of type, if it exists, otherwise the HSQLDB class name.
int	getJDBCPrecision()
int	getJDBCTypeCode() Returns the JDBC type number of type, if it exists, otherwise the HSQLDB / SQL type.
java.lang.String	getNameString() Returns the name of the type
int	getPart(Session session, java.lang.Object interval, int part)
static java.lang.String	getQualifier(int type)
java.math.BigDecimal	getSecondPart(java.lang.Object interval)
long	getSeconds(java.lang.Object interval)
int	getSQLGenericTypeCode() Returns the generic SQL CLI type number of type, if it exists, otherwise the HSQLDB type.
int	getStartIntervalType()
static int	getStartIntervalType(int type)
boolean	isDaySecondIntervalType()
boolean	isIntervalType()
boolean	isYearMonthIntervalType()
java.lang.Object	multiply(java.lang.Object a, java.lang.Object b)
java.lang.Object	negate(java.lang.Object a)
static IntervalType	newIntervalType(int type, long precision, int fractionPrecision)
int	precedenceDegree(Type other)
java.lang.Object	subtract(Session session, java.lang.Object a, java.lang.Object b, Type otherType)

Methods inherited from class org.hsqldb.types.DTIType

getExtractType, getFieldNameTokenForType, getFieldNameTypeForToken, isValidDatetimeRange, normaliseFraction

Methods inherited from class org.hsqldb.types.Type

acceptsScale, arrayLimitCardinality, canBeAssignedFrom, cardinality, castToType, collectionBaseType, compare, compare, compile, concat, convertSQLToJava, convertToTypeJDBC, duplicate, equals, getAggregateType, getCatalogName, getChangeTimestamp, getCharacterSet, getCollation, getComponents, getDefaultArrayType, getDefaultType, getDefaultTypeWithSize, getFullNameString, getHSQLDBTypeCode, getJDBCScale, getJDBCTypeCode, getMaxPrecision, getMaxScale, getName, getOwner, getPrecisionRadix, getReferences, getSchemaName, getSQL, getType, getType, getType, getTypeDefinition, getTypeForJDBCConvertToken, getTypeNr, hashCode, isArrayType, isBinaryType, isBitType, isBooleanType, isCharacterType, isDateOrTimestampType, isDateTimeType, isDateTimeTypeWithZone, isDecimalType, isDistinctType, isDomainType, isExactNumberType, isIntegralType, isLobType, isMultisetType, isNumberType, isObjectType, isRowType, isStructuredType, isSupportedSQLType, matches, newComparator, requiresPrecision

Methods inherited from class java.lang.Object

getClass, notify, notifyAll, toString, wait, wait, wait

Field Detail

defaultPrecision

public final boolean defaultPrecision

isYearMonth

public final boolean isYearMonth

factorType

public static final NumberType factorType

Method Detail

displaySize

public int displaySize()

Specified by:

displaySize in class Type

getJDBCTypeCode

public int getJDBCTypeCode()

Description copied from class: Type

Returns the JDBC type number of type, if it exists, otherwise the HSQLDB / SQL type.

Specified by:

getJDBCTypeCode in class Type

getJDBCClass

public java.lang.Class getJDBCClass()

Specified by:

getJDBCClass in class Type

getJDBCClassName

public java.lang.String getJDBCClassName()

Description copied from class: Type

Returns the JDBC class name of type, if it exists, otherwise the HSQLDB class name.

Specified by:

getJDBCClassName in class Type

getJDBCPrecision

public int getJDBCPrecision()

Overrides:

getJDBCPrecision in class Type

getSQLGenericTypeCode

public int getSQLGenericTypeCode()

Description copied from class: Type

Returns the generic SQL CLI type number of type, if it exists, otherwise the HSQLDB type. The generic type is returned for DATETIME and INTERVAL types.

Overrides:

getSQLGenericTypeCode in class Type

getNameString

public java.lang.String getNameString()

Description copied from class: Type

Returns the name of the type

Specified by:

getNameString in class Type

getQualifier

public static java.lang.String getQualifier(int type)

getDefinition

public java.lang.String getDefinition()

Description copied from class: Type

Returns the full definition of the type, including parameters

Specified by:

getDefinition in class Type

isIntervalType

public boolean isIntervalType()

Overrides:

isIntervalType in class Type

isYearMonthIntervalType

public boolean isYearMonthIntervalType()

isDaySecondIntervalType

public boolean isDaySecondIntervalType()

acceptsPrecision

public boolean acceptsPrecision()

Overrides:

acceptsPrecision in class Type

acceptsFractionalPrecision

public boolean acceptsFractionalPrecision()

Overrides:

acceptsFractionalPrecision in class Type

getAggregateType

public Type getAggregateType(Type other)

Description copied from class: Type

Common type used in comparison opertions. other must be comparable with this.

Specified by:

getAggregateType in class Type

getCombinedType

public Type getCombinedType(Session session,
                            Type other,
                            int operation)

Description copied from class: Type

Result type of combining values of two types in different opertions. other type is not allways comparable with this, but a operation should be valid without any explicit CAST

Specified by:

getCombinedType in class Type

compare

public int compare(Session session,
                   java.lang.Object a,
                   java.lang.Object b)

Specified by:

compare in class Type

convertToTypeLimits

public java.lang.Object convertToTypeLimits(SessionInterface session,
                                            java.lang.Object a)

Specified by:

convertToTypeLimits in class Type

convertToType

public java.lang.Object convertToType(SessionInterface session,
                                      java.lang.Object a,
                                      Type otherType)

Description copied from class: Type

Same as castToType except for CHARACTER values. Perform string truncation of trailing spaces only. For other long strings, it raises an exception.

Specified by:

convertToType in class Type

convertToDefaultType

public java.lang.Object convertToDefaultType(SessionInterface session,
                                             java.lang.Object a)

Description copied from class: Type

Converts the object to the given type without limit checks. Used for JDBC writes.

Specified by:

convertToDefaultType in class Type

convertJavaToSQL

public java.lang.Object convertJavaToSQL(SessionInterface session,
                                         java.lang.Object a)

Overrides:

convertJavaToSQL in class Type

convertToString

public java.lang.String convertToString(java.lang.Object a)

Specified by:

convertToString in class Type

convertToSQLString

public java.lang.String convertToSQLString(java.lang.Object a)

Specified by:

convertToSQLString in class Type

canConvertFrom

public boolean canConvertFrom(Type otherType)

Specified by:

canConvertFrom in class Type

canMoveFrom

public int canMoveFrom(Type otherType)

Description copied from class: Type

Can convert without changing the object

Overrides:

canMoveFrom in class Type

Returns:

0 always, 1 range check required, -1 never

compareToTypeRange

public int compareToTypeRange(java.lang.Object o)

Overrides:

compareToTypeRange in class Type

absolute

public java.lang.Object absolute(java.lang.Object a)

Description copied from class: Type

All arithmetic ops are called on the pre-determined Type object of the result

Overrides:

absolute in class Type

negate

public java.lang.Object negate(java.lang.Object a)

Overrides:

negate in class Type

add

public java.lang.Object add(Session session,
                            java.lang.Object a,
                            java.lang.Object b,
                            Type otherType)

Overrides:

add in class Type

subtract

public java.lang.Object subtract(Session session,
                                 java.lang.Object a,
                                 java.lang.Object b,
                                 Type otherType)

Overrides:

subtract in class Type

multiply

public java.lang.Object multiply(java.lang.Object a,
                                 java.lang.Object b)

Overrides:

multiply in class Type

divide

public java.lang.Object divide(Session session,
                               java.lang.Object a,
                               java.lang.Object b)

Overrides:

divide in class Type

precedenceDegree

public int precedenceDegree(Type other)

Overrides:

precedenceDegree in class Type

getStartIntervalType

public int getStartIntervalType()

Overrides:

getStartIntervalType in class DTIType

getEndIntervalType

public int getEndIntervalType()

Overrides:

getEndIntervalType in class DTIType

newIntervalType

public static IntervalType newIntervalType(int type,
                                           long precision,
                                           int fractionPrecision)

getIntervalType

public static IntervalType getIntervalType(IntervalType type,
                                           long precision,
                                           int fractionalPrecision)

getIntervalType

public static IntervalType getIntervalType(int type,
                                           long precision,
                                           int fractionPrecision)

getIntervalType

public static IntervalType getIntervalType(int startIndex,
                                           int endIndex,
                                           long precision,
                                           int fractionPrecision)

getIntervalType

public static IntervalType getIntervalType(int type,
                                           int startType,
                                           int endType,
                                           long precision,
                                           int fractionPrecision,
                                           boolean defaultPrecision)

getStartIntervalType

public static int getStartIntervalType(int type)

getEndIntervalType

public static int getEndIntervalType(int type)

getCombinedIntervalType

public static Type getCombinedIntervalType(IntervalType type1,
                                           IntervalType type2)

getCombinedIntervalType

public static int getCombinedIntervalType(int startType,
                                          int endType)

getIntervalType

public static int getIntervalType(java.lang.String part)

getPart

public int getPart(Session session,
                   java.lang.Object interval,
                   int part)

Specified by:

getPart in class DTIType

getSeconds

public long getSeconds(java.lang.Object interval)

getSecondPart

public java.math.BigDecimal getSecondPart(java.lang.Object interval)

Specified by:

getSecondPart in class DTIType

convertToLongEndUnits

public long convertToLongEndUnits(java.lang.Object interval)

convertToDoubleStartUnits

public double convertToDoubleStartUnits(java.lang.Object interval)

getCharacterType

public CharacterType getCharacterType()