Class SQLTimestamp

java.lang.Object

org.apache.derby.iapi.types.DataType

org.apache.derby.iapi.types.SQLTimestamp

All Implemented Interfaces:

Externalizable, Serializable, Comparable, Formatable, Storable, TypedFormat, DataValueDescriptor, DateTimeDataValue, Orderable

public final class SQLTimestamp
extends DataType
implements DateTimeDataValue

This contains an instance of a SQL Timestamp object.

SQLTimestamp is stored in 3 ints - an encoded date, an encoded time and nanoseconds encodedDate = 0 indicates a null WSCTimestamp SQLTimestamp is similar to SQLTimestamp, but it does conserves space by not keeping a GregorianCalendar object PERFORMANCE OPTIMIZATION: We only instantiate the value field when required due to the overhead of the Date methods. Thus, use isNull() instead of "value == null" and getTimestamp() instead of using value directly.

See Also:

• Serialized Form

Field Summary

Fields

Modifier and Type	Field	Description
private static final int	BASE_MEMORY_USAGE
(package private) static final char	DATE_SEPARATOR
private static final char[]	DATE_SEPARATORS
private static final char[]	DATE_TIME_SEPARATORS
private static final char[]	DATE_TIME_SEPARATORS_OR_END
private int	encodedDate
private int	encodedTime
private static final char[]	END_OF_STRING
(package private) static final int	FRACTION_TO_NANO
private static final char	IBM_DATE_TIME_SEPARATOR
private static final char	IBM_TIME_SEPARATOR
(package private) static final int	MAX_FRACTION_DIGITS
private int	nanos
private static final char	ODBC_DATE_TIME_SEPARATOR
private static final char	ODBC_TIME_SEPARATOR
(package private) static final int	ONE_BILLION
private static final char[]	TIME_SEPARATORS
private static final char[]	TIME_SEPARATORS_OR_END

Fields inherited from interface DataValueDescriptor

UNKNOWN_LOGICAL_LENGTH

Fields inherited from interface DateTimeDataValue

DAY_FIELD, DAY_INTERVAL, FRAC_SECOND_INTERVAL, HOUR_FIELD, HOUR_INTERVAL, MINUTE_FIELD, MINUTE_INTERVAL, MONTH_FIELD, MONTH_INTERVAL, QUARTER_INTERVAL, SECOND_FIELD, SECOND_INTERVAL, WEEK_INTERVAL, YEAR_FIELD, YEAR_INTERVAL

Fields inherited from interface Orderable

ORDER_OP_EQUALS, ORDER_OP_GREATEROREQUALS, ORDER_OP_GREATERTHAN, ORDER_OP_LESSOREQUALS, ORDER_OP_LESSTHAN

Constructor Summary

Constructors

Constructor	Description
SQLTimestamp()	no-arg constructor required by Formattable
SQLTimestamp(int encodedDate, int encodedTime, int nanos)
SQLTimestamp(String timestampStr, boolean isJDBCEscape, LocaleFinder localeFinder)	Construct a timestamp from a string.
SQLTimestamp(String timestampStr, boolean isJDBCEscape, LocaleFinder localeFinder, Calendar cal)	Construct a timestamp from a string.
SQLTimestamp(Timestamp value)	Create a new SQLTimestamp instance that represents the specified Timestamp in the local time zone.
SQLTimestamp(Timestamp value, Calendar cal)	Create a new SQLTimestamp instance that represents the specified Timestamp in the time zone of the given Calendar.
SQLTimestamp(DataValueDescriptor date, DataValueDescriptor time)

Method Summary

Modifier and Type	Method	Description
private void	addInternal(int calIntervalType, int count, SQLTimestamp tsResult)
DataValueDescriptor	cloneValue(boolean forceMaterialization)	Clone this DataValueDescriptor.
boolean	compare(int op, DataValueDescriptor other, boolean orderedNulls, boolean unknownRV)	Compare this Orderable with a given Orderable for the purpose of qualification and sorting.
int	compare(DataValueDescriptor other)	Compare this Orderable with a given Orderable for the purpose of index positioning.
private static int	computeEncodedDate(Date value, Calendar currentCal)	computeEncodedDate sets the date in a Calendar object and then uses the SQLDate function to compute an encoded date The encoded date is year << 16 + month << 8 + date
private static int	computeEncodedTime(Date value, Calendar currentCal)	computeEncodedTime extracts the hour, minute and seconds from a java.util.Date value and encodes them as hour << 16 + minute << 8 + second using the SQLTime function for encoding the data
static DateTimeDataValue	computeTimestampFunction(DataValueDescriptor operand, DataValueFactory dvf)	Compute the SQL timestamp function.
int	estimateMemoryUsage()	Estimate the memory usage in bytes of the data value and the overhead of the class.
Date	getDate(Calendar cal)	getDate returns the date portion of the timestamp Time is set to 00:00:00.0 Since Date is a JDBC object we use the JDBC definition for the time portion.
NumberDataValue	getDate(NumberDataValue result)	Get the day of the month.
NumberDataValue	getHours(NumberDataValue result)	Get the hour of the day out of a time or timestamp.
int	getLength()	Gets the length of the data value.
NumberDataValue	getMinutes(NumberDataValue result)	Get the minute of the hour out of a time or timestamp.
NumberDataValue	getMonth(NumberDataValue result)	Get the month number out of a date.
DataValueDescriptor	getNewNull()	Get a new null value of the same type as this data value.
Object	getObject()	Gets the value in the data value descriptor as a int.
NumberDataValue	getSeconds(NumberDataValue source)	Get the second of the minute out of a time or timestamp.
String	getString()	Gets the value in the data value descriptor as a String.
Time	getTime(Calendar cal)	getTime returns the time portion of the timestamp Date is set to 1970-01-01 Since Time is a JDBC object we use the JDBC definition for the date portion.
Timestamp	getTimestamp(Calendar cal)	Get the value field.
int	getTypeFormatId()	Return my format identifier.
String	getTypeName()	Get the SQL name of the datatype
NumberDataValue	getYear(NumberDataValue result)	Get the year number out of a date.
int	hashCode()
final boolean	isNull()	Check if the value is null.
(package private) NumberDataValue	nullValueDouble()
(package private) NumberDataValue	nullValueInt()
(package private) static int[]	parseDateOrTimestamp(DateTimeParser parser, boolean timeRequired)	Parse a timestamp or a date.
(package private) static int	parseDateTimeInteger(String str, int start, int ndigits)
(package private) static int[]	parseLocalTimestamp(String str, LocaleFinder localeFinder, Calendar cal)	Parse a localized timestamp.
private void	parseTimestamp(String timestampStr, boolean isJDBCEscape, LocaleFinder localeFinder, Calendar cal)
(package private) static SQLTimestamp	promote(DateTimeDataValue dateTime, Date currentDate)	Promotes a DateTimeDataValue to a timestamp.
void	readExternal(ObjectInput in)
void	restoreToNull()	Restore this object to its (SQL)null value.
private void	setCalendar(Calendar cal)
protected void	setFrom(DataValueDescriptor theValue)	Set the value of this DataValueDescriptor based on the value of the specified DataValueDescriptor.
void	setInto(PreparedStatement ps, int position)	Set this value into a PreparedStatement.
private void	setNumericTimestamp(Timestamp value, Calendar cal)	Set the encoded values for the timestamp
(package private) void	setObject(Object theValue)	Set the value from a correctly typed Timestamp object.
void	setValue(String theValue)	Set the value of this DataValueDescriptor.
void	setValue(Date value, Calendar cal)	Set the value of this DataValueDescriptor.
void	setValue(Timestamp value, Calendar cal)	Set the value of this DataValueDescriptor.
void	setValueFromResultSet(ResultSet resultSet, int colNumber, boolean isNullable)	Set the value based on the value for the specified DataValueDescriptor from the specified ResultSet.
DateTimeDataValue	timestampAdd(int intervalType, NumberDataValue count, Date currentDate, DateTimeDataValue resultHolder)	Add a number of intervals to a datetime value.
NumberDataValue	timestampDiff(int intervalType, DateTimeDataValue time1, Date currentDate, NumberDataValue resultHolder)	Finds the difference between two datetime values as a number of intervals.
String	toString()
int	typePrecedence()	Each built-in type in JSQL has a precedence.
void	writeExternal(ObjectOutput out)

Methods inherited from class DataType

checkHostVariable, cloneHolder, coalesce, compare, compare, compareTo, dataTypeConversion, equals, equals, flip, genericSetObject, getBoolean, getByte, getBytes, getDouble, getFloat, getInt, getLong, getShort, getStream, getTraceString, getTypeName, greaterOrEquals, greaterThan, hasStream, in, invalidFormat, isNotNull, isNullOp, lessOrEquals, lessThan, normalize, notEquals, outOfRange, readExternalFromArray, recycle, setBigDecimal, setInto, setObjectForCast, setToNull, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, throwLangSetMismatch, throwLangSetMismatch, typeToBigDecimal

Methods inherited from class Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface DataValueDescriptor

checkHostVariable, cloneHolder, coalesce, compare, compare, equals, getBoolean, getByte, getBytes, getDouble, getFloat, getInt, getLong, getShort, getStream, getTraceString, greaterOrEquals, greaterThan, hasStream, in, isNotNull, isNullOp, lessOrEquals, lessThan, normalize, notEquals, readExternalFromArray, recycle, setBigDecimal, setInto, setObjectForCast, setToNull, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, typeToBigDecimal

Field Details

MAX_FRACTION_DIGITS

static final int MAX_FRACTION_DIGITS

See Also:

• Constant Field Values

FRACTION_TO_NANO

static final int FRACTION_TO_NANO

See Also:

• Constant Field Values

ONE_BILLION

static final int ONE_BILLION

See Also:

• Constant Field Values

encodedDate

private int encodedDate

encodedTime

private int encodedTime

nanos

private int nanos

BASE_MEMORY_USAGE

private static final int BASE_MEMORY_USAGE

DATE_SEPARATOR

static final char DATE_SEPARATOR

See Also:

• Constant Field Values

DATE_SEPARATORS

private static final char[] DATE_SEPARATORS

IBM_DATE_TIME_SEPARATOR

private static final char IBM_DATE_TIME_SEPARATOR

See Also:

• Constant Field Values

ODBC_DATE_TIME_SEPARATOR

private static final char ODBC_DATE_TIME_SEPARATOR

See Also:

• Constant Field Values

DATE_TIME_SEPARATORS

private static final char[] DATE_TIME_SEPARATORS

DATE_TIME_SEPARATORS_OR_END

private static final char[] DATE_TIME_SEPARATORS_OR_END

IBM_TIME_SEPARATOR

private static final char IBM_TIME_SEPARATOR

See Also:

• Constant Field Values

ODBC_TIME_SEPARATOR

private static final char ODBC_TIME_SEPARATOR

See Also:

• Constant Field Values

TIME_SEPARATORS

private static final char[] TIME_SEPARATORS

TIME_SEPARATORS_OR_END

private static final char[] TIME_SEPARATORS_OR_END

END_OF_STRING

private static final char[] END_OF_STRING

Constructor Details

SQLTimestamp

public SQLTimestamp()

no-arg constructor required by Formattable

SQLTimestamp

public SQLTimestamp(Timestamp value,
 Calendar cal)
             throws StandardException

Create a new SQLTimestamp instance that represents the specified Timestamp in the time zone of the given Calendar.

Parameters:

value - the Timestamp value to be represented by this instance

cal - the time zone of the calendar is used to construct the database timestamp value

Throws:

StandardException - if an error occurs

SQLTimestamp

public SQLTimestamp(Timestamp value)
             throws StandardException

Create a new SQLTimestamp instance that represents the specified Timestamp in the local time zone.

Parameters:

value - the Timestamp value to be represented by this instance

Throws:

StandardException - if an error occurs

SQLTimestamp

SQLTimestamp(int encodedDate,
 int encodedTime,
 int nanos)

SQLTimestamp

public SQLTimestamp(DataValueDescriptor date,
 DataValueDescriptor time)
             throws StandardException

Throws:

StandardException

SQLTimestamp

public SQLTimestamp(String timestampStr,
 boolean isJDBCEscape,
 LocaleFinder localeFinder)
             throws StandardException

Construct a timestamp from a string. The allowed formats are:

1. JDBC escape: yyyy-mm-dd hh:mm:ss[.fffff]
2. IBM: yyyy-mm-dd-hh.mm.ss[.nnnnnn]

The format is specified by a parameter to the constructor. Leading zeroes may be omitted from the month, day, and hour part of the timestamp. The microsecond part may be omitted or truncated.

Throws:

StandardException

SQLTimestamp

public SQLTimestamp(String timestampStr,
 boolean isJDBCEscape,
 LocaleFinder localeFinder,
 Calendar cal)
             throws StandardException

Construct a timestamp from a string. The allowed formats are:

1. JDBC escape: yyyy-mm-dd hh:mm:ss[.fffff]
2. IBM: yyyy-mm-dd-hh.mm.ss[.nnnnnn]

The format is specified by a parameter to the constructor. Leading zeroes may be omitted from the month, day, and hour part of the timestamp. The microsecond part may be omitted or truncated.

Throws:

StandardException

Method Details

estimateMemoryUsage

public int estimateMemoryUsage()

Description copied from interface: DataValueDescriptor

Estimate the memory usage in bytes of the data value and the overhead of the class.

Specified by:

estimateMemoryUsage in interface DataValueDescriptor

Returns:

the estimated memory usage

getString

public String getString()

Description copied from interface: DataValueDescriptor

Gets the value in the data value descriptor as a String. Throws an exception if the data value is not a string.

Specified by:

getString in interface DataValueDescriptor

Returns:

The data value as a String.

getDate

public Date getDate(Calendar cal)
             throws StandardException

getDate returns the date portion of the timestamp Time is set to 00:00:00.0 Since Date is a JDBC object we use the JDBC definition for the time portion. See JDBC API Tutorial, 47.3.12.

Specified by:

getDate in interface DataValueDescriptor

Overrides:

getDate in class DataType

Parameters:

cal - calendar for object creation

Returns:

The data value as a java.sql.Date.

Throws:

StandardException - thrown on failure

getTime

public Time getTime(Calendar cal)
             throws StandardException

getTime returns the time portion of the timestamp Date is set to 1970-01-01 Since Time is a JDBC object we use the JDBC definition for the date portion. See JDBC API Tutorial, 47.3.12.

Specified by:

getTime in interface DataValueDescriptor

Overrides:

getTime in class DataType

Parameters:

cal - calendar for object creation

Returns:

The data value as a java.sql.Time.

Throws:

StandardException - thrown on failure

getObject

public Object getObject()

Description copied from class: DataType

Gets the value in the data value descriptor as a int. Throws an exception if the data value is not receivable as a int.

Specified by:

getObject in interface DataValueDescriptor

Overrides:

getObject in class DataType

Returns:

The data value as a int.

getLength

public int getLength()

Description copied from interface: DataValueDescriptor

Gets the length of the data value. The meaning of this is implementation-dependent. For string types, it is the number of characters in the string. For numeric types, it is the number of bytes used to store the number. This is the actual length of this value, not the length of the type it was defined as. For example, a VARCHAR value may be shorter than the declared VARCHAR (maximum) length.

Specified by:

getLength in interface DataValueDescriptor

Returns:

The length of the data value

getTypeName

public String getTypeName()

Description copied from interface: DataValueDescriptor

Get the SQL name of the datatype

Specified by:

getTypeName in interface DataValueDescriptor

Returns:

The SQL name of the datatype

getTypeFormatId

public int getTypeFormatId()

Return my format identifier.

Specified by:

getTypeFormatId in interface TypedFormat

Returns:

The identifier. (A UUID stuffed in an array of 16 bytes).

See Also:

• TypedFormat.getTypeFormatId()

writeExternal

public void writeExternal(ObjectOutput out)
                   throws IOException

Specified by:

writeExternal in interface Externalizable

Throws:

IOException - error writing data

readExternal

public void readExternal(ObjectInput in)
                  throws IOException

Specified by:

readExternal in interface Externalizable

Throws:

IOException - Thrown on error reading the object

See Also:

• Externalizable.readExternal(ObjectInput)

cloneValue

public DataValueDescriptor cloneValue(boolean forceMaterialization)

Description copied from interface: DataValueDescriptor

Clone this DataValueDescriptor. Results in a new object that has the same value as this but can be modified independently.

Even though the objects can be modified independently regardless of the value of forceMaterialization, both the clone and the original may be dependent on the store state if forceMaterialization is set to false. An example is if you need to access the value you just read using cloneValue after the current transaction has ended, or after the source result set has been closed.

Specified by:

cloneValue in interface DataValueDescriptor

Parameters:

forceMaterialization - any streams representing the data value will be materialized if true, the data value will be kept as a stream if possible if false

Returns:

A clone of the DataValueDescriptor with the same initial value as this.

See Also:

• DataValueDescriptor.cloneValue(boolean)

getNewNull

public DataValueDescriptor getNewNull()

Description copied from interface: DataValueDescriptor

Get a new null value of the same type as this data value.

Specified by:

getNewNull in interface DataValueDescriptor

See Also:

• DataValueDescriptor.getNewNull()

restoreToNull

public void restoreToNull()

Description copied from interface: Storable

Restore this object to its (SQL)null value.

Specified by:

restoreToNull in interface Storable

See Also:

• Storable.restoreToNull()

setValueFromResultSet

public void setValueFromResultSet(ResultSet resultSet,
 int colNumber,
 boolean isNullable)
                           throws SQLException,
StandardException

Description copied from interface: DataValueDescriptor

Set the value based on the value for the specified DataValueDescriptor from the specified ResultSet.

Specified by:

setValueFromResultSet in interface DataValueDescriptor

Parameters:

resultSet - The specified ResultSet.

colNumber - The 1-based column # into the resultSet.

isNullable - Whether or not the column is nullable (No need to call wasNull() if not)

Throws:

SQLException - Thrown on error

StandardException - Thrown on error

See Also:

• DataValueDescriptor.setValueFromResultSet(ResultSet, int, boolean)

compare

public int compare(DataValueDescriptor other)
            throws StandardException

Description copied from interface: DataValueDescriptor

Compare this Orderable with a given Orderable for the purpose of index positioning. This method treats nulls as ordered values - that is, it treats SQL null as equal to null and greater than all other values.

Specified by:

compare in interface DataValueDescriptor

Parameters:

other - The Orderable to compare this one to.

Returns:

<0 - this Orderable is less than other. 0 - this Orderable equals other. >0 - this Orderable is greater than other. The code should not explicitly look for -1, or 1.

Throws:

StandardException - Thrown on error

compare

public boolean compare(int op,
 DataValueDescriptor other,
 boolean orderedNulls,
 boolean unknownRV)
                throws StandardException

Description copied from interface: DataValueDescriptor

Compare this Orderable with a given Orderable for the purpose of qualification and sorting. The caller gets to determine how nulls should be treated - they can either be ordered values or unknown values.

Specified by:

compare in interface DataValueDescriptor

Overrides:

compare in class DataType

Parameters:

op - Orderable.ORDER_OP_EQUALS means do an = comparison. Orderable.ORDER_OP_LESSTHAN means compare this < other. Orderable.ORDER_OP_LESSOREQUALS means compare this <= other.

other - The DataValueDescriptor to compare this one to.

orderedNulls - True means to treat nulls as ordered values, that is, treat SQL null as equal to null, and less than all other values. False means to treat nulls as unknown values, that is, the result of any comparison with a null is the UNKNOWN truth value.

unknownRV - The return value to use if the result of the comparison is the UNKNOWN truth value. In other words, if orderedNulls is false, and a null is involved in the comparison, return unknownRV. This parameter is not used orderedNulls is true.

Returns:

true if the comparison is true (duh!)

Throws:

StandardException - thrown on error

parseTimestamp

private void parseTimestamp(String timestampStr,
 boolean isJDBCEscape,
 LocaleFinder localeFinder,
 Calendar cal)
                     throws StandardException

Throws:

StandardException

parseLocalTimestamp

static int[] parseLocalTimestamp(String str,
 LocaleFinder localeFinder,
 Calendar cal)
                          throws StandardException,
ParseException

Parse a localized timestamp.

Parameters:

str - the timestamp string, with trailing blanks removed.

localeFinder -

Returns:

a {encodedDate, encodedTime} array.

Throws:

ParseException - If the string is not a valid timestamp.

StandardException

parseDateOrTimestamp

static int[] parseDateOrTimestamp(DateTimeParser parser,
 boolean timeRequired)
                           throws StandardException

Parse a timestamp or a date. DB2 allows timestamps to be used as dates or times. So date('2004-04-15-16.15.32') is valid, as is date('2004-04-15'). This method does not handle localized timestamps.

Parameters:

parser - a DateTimeParser initialized with a string.

timeRequired - If true then an error will be thrown if the time is missing. If false then the time may be omitted.

Returns:

{encodedDate, encodedTime, nanosecond} array.

Throws:

StandardException - if the syntax is incorrect for an IBM standard timestamp.

setObject

void setObject(Object theValue)
        throws StandardException

Set the value from a correctly typed Timestamp object.

Overrides:

setObject in class DataType

Throws:

StandardException

setFrom

protected void setFrom(DataValueDescriptor theValue)
                throws StandardException

Description copied from class: DataType

Set the value of this DataValueDescriptor based on the value of the specified DataValueDescriptor.

Overrides:

setFrom in class DataType

Parameters:

theValue - The DataValueDescriptor that holds the value to which we want to set this DataValueDescriptor's value.

Throws:

StandardException

setValue

public void setValue(Date value,
 Calendar cal)
              throws StandardException

Description copied from class: DataType

Set the value of this DataValueDescriptor. At DataType level just throws an error lower classes will override

Specified by:

setValue in interface DataValueDescriptor

Overrides:

setValue in class DataType

Parameters:

value - The Date value to set this DataValueDescriptor to

cal - The time zone from the calendar is used to construct the database date value

Throws:

StandardException

See Also:

• When converting from a date to a timestamp, time is set to 00:00:00.0

setValue

public void setValue(Timestamp value,
 Calendar cal)
              throws StandardException

Description copied from class: DataType

Set the value of this DataValueDescriptor. At DataType level just throws an error lower classes will override

Specified by:

setValue in interface DataValueDescriptor

Overrides:

setValue in class DataType

Parameters:

value - The Timestamp value to set this DataValueDescriptor to

cal - The time zone from the calendar is used to construct the database timestamp value

Throws:

StandardException

See Also:

• DataValueDescriptor.setValue(int)

setValue

public void setValue(String theValue)
              throws StandardException

Description copied from class: DataType

Set the value of this DataValueDescriptor. At DataType level just throws an error lower classes will override

Specified by:

setValue in interface DataValueDescriptor

Overrides:

setValue in class DataType

Parameters:

theValue - The BigDecimal value to set this DataValueDescriptor to

Throws:

StandardException

nullValueInt

NumberDataValue nullValueInt()

nullValueDouble

NumberDataValue nullValueDouble()

getYear

public NumberDataValue getYear(NumberDataValue result)
                        throws StandardException

Description copied from interface: DateTimeDataValue

Get the year number out of a date.

Specified by:

getYear in interface DateTimeDataValue

Parameters:

result - The result of the previous call to this method, null if not called yet.

Returns:

A NumberDataValue containing the year number.

Throws:

StandardException - Thrown on error

See Also:

• DateTimeDataValue.getYear(NumberDataValue)

getMonth

public NumberDataValue getMonth(NumberDataValue result)
                         throws StandardException

Description copied from interface: DateTimeDataValue

Get the month number out of a date.

Specified by:

getMonth in interface DateTimeDataValue

Parameters:

result - The result of the previous call to this method, null if not called yet.

Returns:

A NumberDataValue containing the month number.

Throws:

StandardException - Thrown on error

See Also:

• DateTimeDataValue.getMonth(NumberDataValue)

getDate

public NumberDataValue getDate(NumberDataValue result)
                        throws StandardException

Description copied from interface: DateTimeDataValue

Get the day of the month.

Specified by:

getDate in interface DateTimeDataValue

Parameters:

result - The result of the previous call to this method, null if not called yet.

Returns:

A NumberDataValue containing the day of the month.

Throws:

StandardException - Thrown on error

See Also:

• DateTimeDataValue.getDate(NumberDataValue)

getHours

public NumberDataValue getHours(NumberDataValue result)
                         throws StandardException

Description copied from interface: DateTimeDataValue

Get the hour of the day out of a time or timestamp.

Specified by:

getHours in interface DateTimeDataValue

Parameters:

result - The result of the previous call to this method, null if not called yet.

Returns:

A NumberDataValue containing the hour of the day.

Throws:

StandardException - Thrown on error

See Also:

• DateTimeDataValue.getHours(NumberDataValue)

getMinutes

public NumberDataValue getMinutes(NumberDataValue result)
                           throws StandardException

Description copied from interface: DateTimeDataValue

Get the minute of the hour out of a time or timestamp.

Specified by:

getMinutes in interface DateTimeDataValue

Parameters:

result - The result of the previous call to this method, null if not called yet.

Returns:

A NumberDataValue containing the minute of the hour.

Throws:

StandardException - Thrown on error

See Also:

• DateTimeDataValue.getMinutes(NumberDataValue)

getSeconds

public NumberDataValue getSeconds(NumberDataValue source)
                           throws StandardException

Description copied from interface: DateTimeDataValue

Get the second of the minute out of a time or timestamp.

Specified by:

getSeconds in interface DateTimeDataValue

Parameters:

source - The result of the previous call to this method, null if not called yet.

Returns:

A NumberDataValue containing the second of the minute.

Throws:

StandardException - Thrown on error

See Also:

• DateTimeDataValue.getSeconds(NumberDataValue)

toString

public String toString()

Overrides:

toString in class Object

hashCode

public int hashCode()

Overrides:

hashCode in class Object

typePrecedence

public int typePrecedence()

Description copied from class: DataType

Each built-in type in JSQL has a precedence. This precedence determines how to do type promotion when using binary operators. For example, float has a higher precedence than int, so when adding an int to a float, the result type is float. The precedence for some types is arbitrary. For example, it doesn't matter what the precedence of the boolean type is, since it can't be mixed with other types. But the precedence for the number types is critical. The SQL standard requires that exact numeric types be promoted to approximate numeric when one operator uses both. Also, the precedence is arranged so that one will not lose precision when promoting a type.

Specified by:

typePrecedence in interface DataValueDescriptor

Overrides:

typePrecedence in class DataType

Returns:

The precedence of this type.

See Also:

• DataValueDescriptor.typePrecedence()

isNull

public final boolean isNull()

Check if the value is null. encodedDate value of 0 is null

Specified by:

isNull in interface Storable

Returns:

Whether or not value is logically null.

getTimestamp

public Timestamp getTimestamp(Calendar cal)

Get the value field. We instantiate the field on demand.

Specified by:

getTimestamp in interface DataValueDescriptor

Overrides:

getTimestamp in class DataType

Parameters:

cal - calendar for object creation

Returns:

The value field.

setCalendar

private void setCalendar(Calendar cal)

setNumericTimestamp

private void setNumericTimestamp(Timestamp value,
 Calendar cal)
                          throws StandardException

Set the encoded values for the timestamp

Throws:

StandardException

computeEncodedDate

private static int computeEncodedDate(Date value,
 Calendar currentCal)
                               throws StandardException

computeEncodedDate sets the date in a Calendar object and then uses the SQLDate function to compute an encoded date The encoded date is year << 16 + month << 8 + date

Parameters:

value - the value to convert

Returns:

the encodedDate

Throws:

StandardException

computeEncodedTime

private static int computeEncodedTime(Date value,
 Calendar currentCal)
                               throws StandardException

computeEncodedTime extracts the hour, minute and seconds from a java.util.Date value and encodes them as hour << 16 + minute << 8 + second using the SQLTime function for encoding the data

Parameters:

value - the value to convert

Returns:

the encodedTime

Throws:

StandardException

setInto

public void setInto(PreparedStatement ps,
 int position)
             throws SQLException,
StandardException

Description copied from interface: DataValueDescriptor

Set this value into a PreparedStatement. This method must handle setting NULL into the PreparedStatement.

Specified by:

setInto in interface DataValueDescriptor

Overrides:

setInto in class DataType

Throws:

SQLException - thrown by the PreparedStatement object

StandardException - thrown by me accessing my value.

computeTimestampFunction

public static DateTimeDataValue computeTimestampFunction(DataValueDescriptor operand,
 DataValueFactory dvf)
                                                  throws StandardException

Compute the SQL timestamp function.

Throws:

StandardException

parseDateTimeInteger

static int parseDateTimeInteger(String str,
 int start,
 int ndigits)
                         throws StandardException

Throws:

StandardException

timestampAdd

public DateTimeDataValue timestampAdd(int intervalType,
 NumberDataValue count,
 Date currentDate,
 DateTimeDataValue resultHolder)
                               throws StandardException

Add a number of intervals to a datetime value. Implements the JDBC escape TIMESTAMPADD function.

Specified by:

timestampAdd in interface DateTimeDataValue

Parameters:

intervalType - One of FRAC_SECOND_INTERVAL, SECOND_INTERVAL, MINUTE_INTERVAL, HOUR_INTERVAL, DAY_INTERVAL, WEEK_INTERVAL, MONTH_INTERVAL, QUARTER_INTERVAL, or YEAR_INTERVAL

count - The number of intervals to add

currentDate - Used to convert time to timestamp

resultHolder - If non-null a DateTimeDataValue that can be used to hold the result. If null then generate a new holder

Returns:

startTime + intervalCount intervals, as a timestamp

Throws:

StandardException

addInternal

private void addInternal(int calIntervalType,
 int count,
 SQLTimestamp tsResult)
                  throws StandardException

Throws:

StandardException

timestampDiff

public NumberDataValue timestampDiff(int intervalType,
 DateTimeDataValue time1,
 Date currentDate,
 NumberDataValue resultHolder)
                              throws StandardException

Finds the difference between two datetime values as a number of intervals. Implements the JDBC TIMESTAMPDIFF escape function.

Specified by:

timestampDiff in interface DateTimeDataValue

Parameters:

intervalType - One of FRAC_SECOND_INTERVAL, SECOND_INTERVAL, MINUTE_INTERVAL, HOUR_INTERVAL, DAY_INTERVAL, WEEK_INTERVAL, MONTH_INTERVAL, QUARTER_INTERVAL, or YEAR_INTERVAL

time1 -

currentDate - Used to convert time to timestamp

resultHolder - If non-null a NumberDataValue that can be used to hold the result. If null then generate a new holder

Returns:

the number of intervals by which this datetime is greater than time1

Throws:

StandardException

promote

static SQLTimestamp promote(DateTimeDataValue dateTime,
 Date currentDate)
                     throws StandardException

Promotes a DateTimeDataValue to a timestamp.

Returns:

the corresponding timestamp, using the current date if datetime is a time, or time 00:00:00 if datetime is a date.

Throws:

StandardException