HyperSQL Database 2.7.4 · org.hsqldb.types.DateTimeType

Modifier and Type	Field and Description
public static final long	epochLimitSeconds
public static final TimestampData	epochLimitTimestamp
public static final long	epochSeconds
public static final TimestampData	epochTimestamp
private final String	nameString
public static final TimeZone	systemTimeZone
public final boolean	withTimeZone
public static final HashSet<String>	zoneIDs

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

Method Summary

Modifier and Type	Method and Description
public boolean	acceptsFractionalPrecision() Overrides org.hsqldb.types.Type.acceptsFractionalPrecision.
public Object	add(Session session, Object a, Object b, Type otherType) Overrides org.hsqldb.types.Type.add.
public static TimestampData	addMonths(Session session, TimestampData source, int months)
public Object	addMonthsSpecial(Session session, Object dateTime, int months)
public static TimeData	addSeconds(TimeData source, long seconds, int nanos)
public static TimestampData	addSeconds(TimestampData source, long seconds, int nanos)
public boolean	canAdd(IntervalType other)
public boolean	canCompareDirect(Type otherType) Overrides org.hsqldb.types.Type.canCompareDirect.
public boolean	canConvertFrom(Type otherType) Implements abstract org.hsqldb.types.Type.canConvertFrom.
public int	canMoveFrom(Type otherType) Overrides org.hsqldb.types.Type.canMoveFrom. When canConvertFrom() is true, can convert without changing the object
public Object	changeZone(Session session, Object a, String zoneString)
public Object	changeZone(Session session, Object a, Type otherType, String zoneString)
public Object	changeZone(Session session, Object a, Type otherType, int zoneSeconds, boolean atLocal)
public Object	changeZoneToUTC(Object a)
public int	compare(Session session, Object a, Object b) Implements abstract org.hsqldb.types.Type.compare.
public static Boolean	Returns: `Boolean#TRUE` if period a contains period b, else `Boolean#FALSE` contains(Session The session session, Object[] First period to compare a, Type[] Types of the first period ta, Object[] Second period to compare b, Type[] Type of the second period tb, boolean pointOfTime) The predicate "x CONTAINS y" applies when a) both x and y are either period names or period constructors.
public TimestampData	convertFromDouble(Session session, double value)
pack-priv static String	convertJavaDateTimeObjectToString(Object a)
public Object	convertJavaToSQL(SessionInterface session, Object a) Overrides org.hsqldb.types.Type.convertJavaToSQL.
public Object	convertJavaToSQL(SessionInterface session, Object a, Calendar calendar)
public Object	convertJavaToSQL(SessionInterface session, LocalTime lt)
public Object	convertJavaToSQL(SessionInterface session, OffsetTime ot)
public Object	convertJavaToSQL(SessionInterface session, LocalDate ld)
public Object	convertJavaToSQL(SessionInterface session, LocalDateTime ldt)
public Object	convertJavaToSQL(SessionInterface session, OffsetDateTime odt)
public Object	convertJavaToSQL(SessionInterface session, ZonedDateTime zdt)
public Object	convertSQLToJava(SessionInterface session, Object a) Overrides org.hsqldb.types.Type.convertSQLToJava.
public Object	convertSQLToJava(SessionInterface session, Object a, Calendar cal)
public Object	convertSQLToJavaGMT(SessionInterface session, Object a)
pack-priv TimestampData	convertTimeToTimestamp(Calendar calendar, int timeSeconds, int nanos)
public static TimestampData	convertToDatetimeSpecial(SessionInterface session, String s, DateTimeType type)
public Object	convertToDefaultType(SessionInterface session, Object a) Implements abstract org.hsqldb.types.Type.convertToDefaultType. Converts the object to the given type without limit checks.
public static double	convertToDouble(Object a)
public void	convertToJSON(Object a, StringBuilder sb) Overrides org.hsqldb.types.Type.convertToJSON.
public String	convertToSQLString(Object a) Implements abstract org.hsqldb.types.Type.convertToSQLString.
public String	convertToString(Object a) Implements abstract org.hsqldb.types.Type.convertToString.
public Object	convertToType(SessionInterface session, Object a, Type otherType) Implements abstract org.hsqldb.types.Type.convertToType. Same as castToType except for CHARACTER values.
public Object	convertToTypeLimits(SessionInterface session, Object a) Implements abstract org.hsqldb.types.Type.convertToTypeLimits.
public int	displaySize() Implements abstract org.hsqldb.types.Type.displaySize.
public boolean	equals(Object other) Overrides org.hsqldb.types.Type.equals. Indicates whether some other object is "equal to" this one.
public static Boolean	Returns: `Boolean#TRUE` if period a equals period b, else `Boolean#FALSE` equals(Session The session session, Object[] First period to compare a, Type[] Types of the first period ta, Object[] Second period to compare b, Type[] Type of the second period tb) The predicate "x EQUALS y" applies when both x and y are either period names or period constructors.
public Type	getAggregateType(Type other) Implements abstract org.hsqldb.types.Type.getAggregateType. Common type used in comparison operations.
public Type	getCombinedType(Session session, Type other, int operation) Implements abstract org.hsqldb.types.Type.getCombinedType. Result type of combining values of two types in different operations.
public static DateTimeType	getDateTimeType(int type, int scale)
public TimestampData	getDateTimeValue(SessionInterface session, long seconds, int nanos)
public static int	getDayOfWeek(String name)
public String	getDefinition() Implements abstract org.hsqldb.types.Type.getDefinition. Returns the full definition of the type, including parameters
public Class<T>	getJDBCClass() Implements abstract org.hsqldb.types.Type.getJDBCClass.
public String	getJDBCClassName() Implements abstract org.hsqldb.types.Type.getJDBCClassName. Returns the JDBC class name of type, if it exists, otherwise the HSQLDB class name.
public int	getJDBCPrecision() Overrides org.hsqldb.types.Type.getJDBCPrecision.
public int	getJDBCTypeCode() Implements abstract org.hsqldb.types.Type.getJDBCTypeCode. Returns the JDBC type number of type, if it exists, otherwise the HSQLDB / SQL type.
public Object	getLastDayOfMonth(Session session, Object dateTime)
public String	getNameString() Implements abstract org.hsqldb.types.Type.getNameString. Returns the name of the type
private String	getNameStringPrivate()
public int	getPart(Session session, Object dateTime, int part) Implements abstract org.hsqldb.types.DTIType.getPart.
public String	getPartString(Session session, Object dateTime, int part)
public BigDecimal	getSecondPart(Session session, Object dateTime) Implements abstract org.hsqldb.types.DTIType.getSecondPart.
public int	getSqlDateTimeSub()
public int	getSQLGenericTypeCode() Overrides org.hsqldb.types.Type.getSQLGenericTypeCode. Returns the generic SQL CLI type number of type, if it exists, otherwise the HSQLDB type.
pack-priv long	getTotalMillis(Object dateTime)
pack-priv long	getTotalSeconds(Object dateTime)
pack-priv long	getZoneMillis(Object dateTime)
public static int	getZoneSeconds(long utcSeconds, TimeZone zone)
public static Boolean	Returns: `Boolean#TRUE` if period a immediately precedes period b, else `Boolean#FALSE` immediatelyPrecedes(Session The session session, Object[] First period to compare a, Type[] Types of the first period ta, Object[] Second period to compare b, Type[] Type of the second period tb) The predicate "x IMMEDIATELY PRECEDES y" applies when both x and y are either period names or period constructors.
public static Boolean	Returns: `Boolean#TRUE` if period a immediately succeeds period b, else `Boolean#FALSE` immediatelySucceeds(Session The session session, Object[] First period to compare a, Type[] Types of the first period ta, Object[] Second period to compare b, Type[] Type of the second period tb) The predicate "x IMMEDIATELY SUCCEEDS y" applies when both x and y are either period names or period constructors.
public boolean	isDateOrTimestampType() Overrides org.hsqldb.types.Type.isDateOrTimestampType.
public boolean	isDateTimeType() Overrides org.hsqldb.types.Type.isDateTimeType.
public boolean	isDateTimeTypeWithZone() Overrides org.hsqldb.types.Type.isDateTimeTypeWithZone.
public boolean	isTimestampType() Overrides org.hsqldb.types.Type.isTimestampType.
public boolean	isTimeType() Overrides org.hsqldb.types.Type.isTimeType.
public static TimestampData	newCurrentTimestamp(TimeZone zone)
public static TimestampData	newSysDateTimestamp()
public static TimestampData	newSystemTimestampUTC()
public static TimestampData	newSystemTimestampWithZone()
public static TimestampData	nextDayOfWeek(Session session, TimestampData d, int day)
public static Type	Returns: The common data type of the boundaries of the two limits. null if any of the two periods is null or if the first limit of any period is null. normalizeInput(Session The session session, Object[] First period to compare a, Type[] Types of the first period ta, Object[] Second period to compare b, Type[] Type of the second period tb, boolean pointOfTime) For temporal predicate operations on periods, we need to make sure we compare data of the same types.
public static Type	Returns: The common data type of the boundaries of the two limits. null if any of the two periods is null or if the first limit of any period is null. normalizeInputRelaxed(Session The session session, Object[] First period to compare a, Type[] Types of the first period ta, Object[] Second period to compare b, Type[] Type of the second period tb) For temporal predicate operations on periods, we need to make sure we compare data of the same types.
public static Boolean	Returns: `Boolean#TRUE` if the two periods overlaps, else `Boolean#FALSE` overlaps(Session The session session, Object[] First period to compare a, Type[] Types of the first period ta, Object[] Second period to compare b, Type[] Type of the second period tb) The predicate "a OVERLAPS b" applies when both a and b are either period names or period constructors.
public static Boolean	Returns: `Boolean#TRUE` if the two periods overlaps, else `Boolean#FALSE` overlapsRelaxed(Session The session session, Object[] First period to compare a, Type[] Types of the first period ta, Object[] Second period to compare b, Type[] Type of the second period tb) The predicate "a OVERLAPS b" applies when both a and b are rows.
public static Boolean	Returns: `Boolean#TRUE` if period a precedes period b, else `Boolean#FALSE` precedes(Session The session session, Object[] First period to compare a, Type[] Types of the first period ta, Object[] Second period to compare b, Type[] Type of the second period tb) The predicate "a PRECEDES b" applies when both a and b are either period names or period constructors.
public Object	round(Session session, Object a, int part)
pack-priv int	scaleNanos(int nanos)
public static void	setDateComponents(Calendar calendar, LocalDate ldt)
public static void	setDateTimeComponents(Calendar calendar, LocalDateTime ldt)
pack-priv static void	setTimeComponents(Calendar calendar, int seconds)
pack-priv static void	setTimeComponentsOnly(Calendar calendar, int seconds)
public Object	subtract(Session session, Object a, Object b, Type otherType) Overrides org.hsqldb.types.Type.subtract.
public static int	subtractMonths(Session session, TimestampData a, TimestampData b, boolean isYear)
public static BigDecimal	subtractMonthsSpecial(Session session, TimestampData a, TimestampData b)
public static Boolean	Returns: `Boolean#TRUE` if period a succeeds period b, else `Boolean#FALSE` succeeds(Session The session session, Object[] First period to compare a, Type[] Types of the first period ta, Object[] Second period to compare b, Type[] Type of the second period tb) The predicate "x SUCCEEDS y" applies when both x and y are either period names or period constructors.
public static TimestampData	toCurrentDateValue(TimestampData tsWithZone)
public static TimeData	toCurrentTimeValue(TimestampData tsWithZone)
public static TimeData	toCurrentTimeWithZoneValue(TimestampData tsWithZone)
pack-priv static long	toDateSeconds(long seconds)
public Instant	toInstant(SessionInterface session, TimestampData v)
public LocalDate	toLocalDate(SessionInterface session, TimestampData v)
public LocalDateTime	toLocalDateTime(SessionInterface session, TimestampData v)
public LocalTime	toLocalTime(SessionInterface session, TimeData v)
public LocalTime	toLocalTime(SessionInterface session, TimestampData v)
public static TimestampData	toLocalTimestampValue(TimestampData tsWithZone) Session derivatives of CURRENT_TIMESTAMP
public OffsetDateTime	toOffsetDateTime(SessionInterface session, TimestampData v)
public OffsetTime	toOffsetTime(SessionInterface session, TimeData v)
public OffsetTime	toOffsetTime(SessionInterface session, TimestampData v)
public static int	toTimeSeconds(long seconds)
public Object	truncate(Session session, Object a, int part)

Inherited from org.hsqldb.types.DTIType:: getEndIntervalType getExtractType getFieldNameTokenForType getFieldNameTypeForToken getPrecisionExponent getSecondPart getStartIntervalType intervalSecondToString isValidDatetimeRange normaliseFraction normaliseFraction

public final Class DateTimeType

Field Summary

Constructor Summary

Method Summary