org.hsqldb.types

Class DTIType

java.lang.Object

org.hsqldb.types.Type

org.hsqldb.types.DTIType

All Implemented Interfaces:

java.lang.Cloneable, SchemaObject

Direct Known Subclasses:

DateTimeType, IntervalType

public abstract class DTIType
extends Type

Common elements for Type instances for DATETIME and 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
static int	DAY_NAME
static int	DAY_OF_MONTH
static int	DAY_OF_WEEK
static int	DAY_OF_YEAR
static int	defaultIntervalFractionPrecision
static int	defaultIntervalPrecision
static int	defaultTimeFractionPrecision
static int	defaultTimestampFractionPrecision
int	endIntervalType
int	endPartIndex
static int	INTERVAL_FRACTION_PART_INDEX
static int	INTERVAL_MONTH_INDEX
static int	INTERVAL_SECOND_INDEX
static int	ISO_YEAR
static int	limitNanoseconds
static int	maxFractionPrecision
static int	maxIntervalPrecision
static int	maxIntervalSecondPrecision
static int	MONTH_NAME
static int[]	nanoScaleFactors
static int[]	precisionFactors
static long[]	precisionLimits
static int	QUARTER
static int	SECONDS_MIDNIGHT
int	startIntervalType
int	startPartIndex
static int	TIMEZONE_HOUR
static int	TIMEZONE_MINUTE
static int	timezoneSecondsLimit
static int	WEEK_OF_YEAR
static int[]	yearToSecondFactors
static int[]	yearToSecondLimits
static byte[]	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
int	getEndIntervalType()
Type	getExtractType(int part)
static java.lang.String	getFieldNameTokenForType(int type)
static int	getFieldNameTypeForToken(int token)
abstract int	getPart(Session session, java.lang.Object dateTime, int part)
abstract java.math.BigDecimal	getSecondPart(java.lang.Object dateTime)
int	getStartIntervalType()
static boolean	isValidDatetimeRange(Type a, Type b)
static int	normaliseFraction(int fraction, int precision)

Methods inherited from class org.hsqldb.types.Type

absolute, acceptsFractionalPrecision, acceptsPrecision, acceptsScale, add, arrayLimitCardinality, canBeAssignedFrom, canConvertFrom, canMoveFrom, cardinality, castToType, collectionBaseType, compare, compare, compare, compareToTypeRange, compile, concat, convertJavaToSQL, convertSQLToJava, convertToDefaultType, convertToSQLString, convertToString, convertToType, convertToTypeJDBC, convertToTypeLimits, displaySize, divide, duplicate, equals, getAggregateType, getAggregateType, getCatalogName, getChangeTimestamp, getCharacterSet, getCollation, getCombinedType, getComponents, getDefaultArrayType, getDefaultType, getDefaultTypeWithSize, getDefinition, getFullNameString, getHSQLDBTypeCode, getJDBCClass, getJDBCClassName, getJDBCPrecision, getJDBCScale, getJDBCTypeCode, getJDBCTypeCode, getMaxPrecision, getMaxScale, getName, getNameString, getOwner, getPrecisionRadix, getReferences, getSchemaName, getSQL, getSQLGenericTypeCode, getType, getType, getType, getTypeDefinition, getTypeForJDBCConvertToken, getTypeNr, hashCode, isArrayType, isBinaryType, isBitType, isBooleanType, isCharacterType, isDateOrTimestampType, isDateTimeType, isDateTimeTypeWithZone, isDecimalType, isDistinctType, isDomainType, isExactNumberType, isIntegralType, isIntervalType, isLobType, isMultisetType, isNumberType, isObjectType, isRowType, isStructuredType, isSupportedSQLType, matches, multiply, negate, newComparator, precedenceDegree, requiresPrecision, subtract

Methods inherited from class java.lang.Object

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

Field Detail

yearToSecondSeparators

public static final byte[] yearToSecondSeparators

yearToSecondFactors

public static final int[] yearToSecondFactors

yearToSecondLimits

public static final int[] yearToSecondLimits

INTERVAL_MONTH_INDEX

public static final int INTERVAL_MONTH_INDEX

See Also:

Constant Field Values

INTERVAL_SECOND_INDEX

public static final int INTERVAL_SECOND_INDEX

See Also:

Constant Field Values

INTERVAL_FRACTION_PART_INDEX

public static final int INTERVAL_FRACTION_PART_INDEX

See Also:

Constant Field Values

precisionLimits

public static final long[] precisionLimits

precisionFactors

public static final int[] precisionFactors

nanoScaleFactors

public static final int[] nanoScaleFactors

timezoneSecondsLimit

public static final int timezoneSecondsLimit

See Also:

Constant Field Values

TIMEZONE_HOUR

public static final int TIMEZONE_HOUR

See Also:

Constant Field Values

TIMEZONE_MINUTE

public static final int TIMEZONE_MINUTE

See Also:

Constant Field Values

DAY_OF_WEEK

public static final int DAY_OF_WEEK

See Also:

Constant Field Values

DAY_OF_MONTH

public static final int DAY_OF_MONTH

See Also:

Constant Field Values

DAY_OF_YEAR

public static final int DAY_OF_YEAR

See Also:

Constant Field Values

WEEK_OF_YEAR

public static final int WEEK_OF_YEAR

See Also:

Constant Field Values

QUARTER

public static final int QUARTER

See Also:

Constant Field Values

DAY_NAME

public static final int DAY_NAME

See Also:

Constant Field Values

MONTH_NAME

public static final int MONTH_NAME

See Also:

Constant Field Values

SECONDS_MIDNIGHT

public static final int SECONDS_MIDNIGHT

See Also:

Constant Field Values

ISO_YEAR

public static final int ISO_YEAR

See Also:

Constant Field Values

startIntervalType

public final int startIntervalType

endIntervalType

public final int endIntervalType

startPartIndex

public final int startPartIndex

endPartIndex

public final int endPartIndex

defaultTimeFractionPrecision

public static final int defaultTimeFractionPrecision

See Also:

Constant Field Values

defaultTimestampFractionPrecision

public static final int defaultTimestampFractionPrecision

See Also:

Constant Field Values

defaultIntervalPrecision

public static final int defaultIntervalPrecision

See Also:

Constant Field Values

defaultIntervalFractionPrecision

public static final int defaultIntervalFractionPrecision

See Also:

Constant Field Values

maxIntervalPrecision

public static final int maxIntervalPrecision

See Also:

Constant Field Values

maxIntervalSecondPrecision

public static final int maxIntervalSecondPrecision

See Also:

Constant Field Values

maxFractionPrecision

public static final int maxFractionPrecision

See Also:

Constant Field Values

limitNanoseconds

public static final int limitNanoseconds

See Also:

Constant Field Values

Method Detail

getStartIntervalType

public int getStartIntervalType()

getEndIntervalType

public int getEndIntervalType()

getExtractType

public Type getExtractType(int part)

normaliseFraction

public static int normaliseFraction(int fraction,
                                    int precision)

getFieldNameTypeForToken

public static int getFieldNameTypeForToken(int token)

getFieldNameTokenForType

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

isValidDatetimeRange

public static boolean isValidDatetimeRange(Type a,
                                           Type b)

getPart

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

getSecondPart

public abstract java.math.BigDecimal getSecondPart(java.lang.Object dateTime)