org.hsqldb.types

Class DateTimeType

java.lang.Object

org.hsqldb.types.Type

org.hsqldb.types.DTIType

org.hsqldb.types.DateTimeType

All Implemented Interfaces:

java.lang.Cloneable, SchemaObject

public final class DateTimeType
extends DTIType

Type subclass for DATE, TIME and TIMESTAMP.

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 long	epochSeconds
static TimestampData	epochTimestamp
boolean	withTimeZone

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

Constructor Summary

Constructors

Constructor and Description
DateTimeType(int typeGroup, int type, int scale)

Method Summary

Modifier and Type	Method and Description
boolean	acceptsFractionalPrecision()
java.lang.Object	add(Session session, java.lang.Object a, java.lang.Object b, Type otherType)
static TimestampData	addMonths(Session session, TimestampData source, int months)
java.lang.Object	addMonthsSpecial(Session session, java.lang.Object dateTime, int months)
static TimeData	addSeconds(TimeData source, long seconds, int nanos)
static TimestampData	addSeconds(TimestampData source, long seconds, int nanos)
boolean	canAdd(IntervalType other)
boolean	canConvertFrom(Type otherType)
int	canMoveFrom(Type otherType) Can convert without changing the object
java.lang.Object	changeZone(java.lang.Object a, Type otherType, int targetZone, int localZone)
int	compare(Session session, java.lang.Object a, java.lang.Object b)
java.lang.Object	convertJavaToSQL(SessionInterface session, java.lang.Object a)
java.lang.Object	convertSQLToJava(SessionInterface session, java.lang.Object a)
java.lang.Object	convertSQLToJavaGMT(SessionInterface session, java.lang.Object a)
static TimestampData	convertToDatetimeSpecial(SessionInterface session, java.lang.String s, DateTimeType type)
java.lang.Object	convertToDefaultType(SessionInterface session, java.lang.Object a) Converts the object to the given type without limit checks.
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()
boolean	equals(java.lang.Object other)
Type	getAggregateType(Type other) Common type used in comparison opertions.
Type	getCombinedType(Session session, Type other, int operation) Result type of combining values of two types in different opertions.
static DateTimeType	getDateTimeType(int type, int scale)
DateTimeType	getDateTimeTypeWithoutZone()
java.lang.String	getDefinition() Returns the full definition of the type, including parameters
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.Object	getLastDayOfMonth(Session session, java.lang.Object dateTime)
java.lang.String	getNameString() Returns the name of the type
int	getPart(Session session, java.lang.Object dateTime, int part)
java.lang.String	getPartString(Session session, java.lang.Object dateTime, int part)
java.math.BigDecimal	getSecondPart(java.lang.Object dateTime)
int	getSqlDateTimeSub()
int	getSQLGenericTypeCode() Returns the generic SQL CLI type number of type, if it exists, otherwise the HSQLDB type.
java.lang.Object	getValue(long seconds, int nanos, int zoneSeconds)
boolean	isDateOrTimestampType()
boolean	isDateTimeType()
boolean	isDateTimeTypeWithZone()
static int	normaliseTime(int seconds)
static java.lang.Boolean	overlaps(Session session, java.lang.Object[] a, Type[] ta, java.lang.Object[] b, Type[] tb)
java.lang.Object	round(java.lang.Object a, int part)
java.lang.Object	subtract(Session session, java.lang.Object a, java.lang.Object b, Type otherType)
static int	subtractMonths(TimestampData a, TimestampData b, boolean isYear)
static java.math.BigDecimal	subtractMonthsSpecial(Session session, TimestampData a, TimestampData b)
java.lang.Object	truncate(java.lang.Object a, int part)

Methods inherited from class org.hsqldb.types.DTIType

getEndIntervalType, getExtractType, getFieldNameTokenForType, getFieldNameTypeForToken, getStartIntervalType, isValidDatetimeRange, normaliseFraction

Methods inherited from class org.hsqldb.types.Type

absolute, acceptsPrecision, acceptsScale, arrayLimitCardinality, canBeAssignedFrom, cardinality, castToType, collectionBaseType, compare, compare, compareToTypeRange, compile, concat, convertToTypeJDBC, divide, duplicate, 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, isDecimalType, isDistinctType, isDomainType, isExactNumberType, isIntegralType, isIntervalType, isLobType, isMultisetType, isNumberType, isObjectType, isRowType, isStructuredType, isSupportedSQLType, matches, multiply, negate, newComparator, precedenceDegree, requiresPrecision

Methods inherited from class java.lang.Object

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

Field Detail

withTimeZone

public final boolean withTimeZone

epochSeconds

public static final long epochSeconds

epochTimestamp

public static final TimestampData epochTimestamp

Constructor Detail

DateTimeType

public DateTimeType(int typeGroup,
                    int type,
                    int scale)

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

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

isDateTimeType

public boolean isDateTimeType()

Overrides:

isDateTimeType in class Type

isDateOrTimestampType

public boolean isDateOrTimestampType()

Overrides:

isDateOrTimestampType in class Type

isDateTimeTypeWithZone

public boolean isDateTimeTypeWithZone()

Overrides:

isDateTimeTypeWithZone 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

convertSQLToJavaGMT

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

convertSQLToJava

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

Overrides:

convertSQLToJava in class Type

normaliseTime

public static int normaliseTime(int seconds)

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

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

truncate

public java.lang.Object truncate(java.lang.Object a,
                                 int part)

round

public java.lang.Object round(java.lang.Object a,
                              int part)

equals

public boolean equals(java.lang.Object other)

Overrides:

equals in class Type

getPart

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

Specified by:

getPart in class DTIType

addMonthsSpecial

public java.lang.Object addMonthsSpecial(Session session,
                                         java.lang.Object dateTime,
                                         int months)

getLastDayOfMonth

public java.lang.Object getLastDayOfMonth(Session session,
                                          java.lang.Object dateTime)

getSecondPart

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

Specified by:

getSecondPart in class DTIType

getPartString

public java.lang.String getPartString(Session session,
                                      java.lang.Object dateTime,
                                      int part)

getValue

public java.lang.Object getValue(long seconds,
                                 int nanos,
                                 int zoneSeconds)

getDateTimeTypeWithoutZone

public DateTimeType getDateTimeTypeWithoutZone()

getDateTimeType

public static DateTimeType getDateTimeType(int type,
                                           int scale)

changeZone

public java.lang.Object changeZone(java.lang.Object a,
                                   Type otherType,
                                   int targetZone,
                                   int localZone)

canAdd

public boolean canAdd(IntervalType other)

getSqlDateTimeSub

public int getSqlDateTimeSub()

overlaps

public static java.lang.Boolean overlaps(Session session,
                                         java.lang.Object[] a,
                                         Type[] ta,
                                         java.lang.Object[] b,
                                         Type[] tb)

subtractMonthsSpecial

public static java.math.BigDecimal subtractMonthsSpecial(Session session,
                                                         TimestampData a,
                                                         TimestampData b)

subtractMonths

public static int subtractMonths(TimestampData a,
                                 TimestampData b,
                                 boolean isYear)

addSeconds

public static TimeData addSeconds(TimeData source,
                                  long seconds,
                                  int nanos)

addMonths

public static TimestampData addMonths(Session session,
                                      TimestampData source,
                                      int months)

addSeconds

public static TimestampData addSeconds(TimestampData source,
                                       long seconds,
                                       int nanos)

convertToDatetimeSpecial

public static TimestampData convertToDatetimeSpecial(SessionInterface session,
                                                     java.lang.String s,
                                                     DateTimeType type)