org.apache.derby.iapi.types
Class SQLTime

java.lang.Object
  extended byorg.apache.derby.iapi.types.DataType
      extended byorg.apache.derby.iapi.types.SQLTime
All Implemented Interfaces:
CloneableObject, DataValueDescriptor, DateTimeDataValue, java.io.Externalizable, Formatable, Orderable, java.io.Serializable, Storable, TypedFormat

public final class SQLTime
extends DataType
implements DateTimeDataValue

This contains an instance of a SQL Time Our current implementation doesn't implement time precision so the fractional seconds portion of the time is always 0. The default when no time precision is specified is 0 fractional seconds. A SQL Time without timezone information is assumed to be in the local time zone. The local time is stored as is and doesn't change if the timezone changes. This is in conformance with the SQL99 standard. The SQL92 standard indicates that the time is in GMT and changes with the timezone. The SQL99 standard clarifies this to allow time without timezoned to be stored as the local time.

Time is stored as two ints. The first int represents hour, minute, second and the second represents fractional seconds (currently 0 since we don't support time precision) encodedTime = -1 indicates null PERFORMANCE OPTIMIZATION: The java.sql.Time object is only instantiated on demand for performance reasons.

See Also:
Serialized Form

Field Summary
private static java.lang.String[] AM_PM
           
private static char[] ANY_SEPARATOR
           
private static int BASE_MEMORY_USAGE
           
private  int encodedTime
           
private  int encodedTimeFraction
           
private static char[] END_OF_STRING
           
private static char IBM_EUR_SEPARATOR
           
private static char[] IBM_EUR_SEPARATOR_OR_END
           
(package private) static char JIS_SEPARATOR
           
private static char[] US_OR_JIS_MINUTE_END
           
private  java.lang.String valueString
           
 
Fields inherited from interface org.apache.derby.iapi.types.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 org.apache.derby.iapi.types.Orderable
ORDER_OP_EQUALS, ORDER_OP_GREATEROREQUALS, ORDER_OP_GREATERTHAN, ORDER_OP_LESSOREQUALS, ORDER_OP_LESSTHAN
 
Constructor Summary
  SQLTime()
          no-arg constructor required by Formattable
private SQLTime(int encodedTime, int encodedTimeFraction)
           
  SQLTime(java.lang.String timeStr, boolean isJdbcEscape, LocaleFinder localeFinder)
          Construct a time from a string.
  SQLTime(java.lang.String timeStr, boolean isJdbcEscape, LocaleFinder localeFinder, java.util.Calendar cal)
          Construct a time from a string.
  SQLTime(java.sql.Time value)
           
 
Method Summary
 int compare(DataValueDescriptor other)
          Orderable interface
 boolean compare(int op, DataValueDescriptor other, boolean orderedNulls, boolean unknownRV)
          Compare this Orderable with a given Orderable for the purpose of qualification and sorting.
(package private) static int computeEncodedTime(java.util.Calendar cal)
          Calculate the encoded time from a Calendar object encoded time is hour << 16 + min << 8 + sec this function is also used by SQLTimestamp
private  int computeEncodedTime(java.util.Date value)
          Compute encoded time value Time is represented by hour << 16 + minute << 8 + seconds
(package private) static int computeEncodedTime(java.util.Date value, java.util.Calendar currentCal)
           
(package private) static int computeEncodedTime(int hour, int minute, int second)
           
protected static java.lang.String encodedTimeToString(int encodedTime)
          Get the String version from the encodedTime.
 int estimateMemoryUsage()
          Estimate the memory usage in bytes of the data value and the overhead of the class.
 DataValueDescriptor getClone()
          Clone this DataValueDescriptor.
 NumberDataValue getDate(NumberDataValue result)
          Get the day of the month.
(package private)  int getEncodedTime()
           
protected static int getHour(int encodedTime)
          Get the encoded hour value (may be different than hour value for current timezone if value encoded in a different timezone)
 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.
protected static int getMinute(int encodedTime)
          Get the encoded minute value (may be different than the minute value for current timezone if value encoded in a different timezone)
 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.
protected  java.lang.String getNationalString(LocaleFinder localeFinder)
          International version of getString().
 DataValueDescriptor getNewNull()
          Get a new null value of the same type as this data value.
 java.lang.Object getObject()
          Gets the value in the data value descriptor as a Java Object.
protected static int getSecond(int encodedTime)
          Get the encoded second value (may be different than the second value for current timezone if value encoded in a different timezone)
 NumberDataValue getSeconds(NumberDataValue result)
          Get the second of the minute out of a time or timestamp.
 java.lang.String getString()
          Gets the value in the data value descriptor as a String.
 java.sql.Time getTime(java.util.Calendar cal)
          Get the time value Since this is a JDBC object we use the JDBC definition we use the JDBC definition, see JDBC API Tutorial and Reference section 47.3.12 Date is set to Jan. 1, 1970
 java.sql.Timestamp getTimestamp(java.util.Calendar cal)
          Gets the value in the data value descriptor as a java.sql.Timestamp.
 int getTypeFormatId()
          Return my format identifier.
 java.lang.String getTypeName()
          Get the SQL name of the datatype
 NumberDataValue getYear(NumberDataValue result)
          Get the year number out of a date.
 int hashCode()
           
 boolean isNull()
          Check if the value is null.
protected  java.sql.Time newTime(java.util.Calendar cal)
           
private  void parseTime(java.util.Date value)
           
private  void parseTime(java.lang.String timeStr, boolean isJdbcEscape, LocaleFinder localeFinder, java.util.Calendar cal)
           
 void readExternal(java.io.ObjectInput in)
           
 void readExternalFromArray(ArrayInputStream in)
          Read the DataValueDescriptor from the stream.
 void restoreToNull()
          Restore this object to its (SQL)null value.
protected  void setFrom(DataValueDescriptor theValue)
           
 void setInto(java.sql.PreparedStatement ps, int position)
          Adding this method to ensure that super class' setInto method doesn't get called that leads to the violation of JDBC spec( untyped nulls ) when batching is turned on.
 void setValue(java.lang.Object theValue)
          Set the value of this DataValueDescriptor to the given value
 void setValue(java.lang.String theValue)
          Set the value of this DataValueDescriptor.
 void setValue(java.sql.Time value, java.util.Calendar cal)
          Set the value of this DataValueDescriptor.
 void setValue(java.sql.Timestamp value, java.util.Calendar cal)
          Set the value of this DataValueDescriptor.
 void setValueFromResultSet(java.sql.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 intervalCount, java.sql.Date currentDate, DateTimeDataValue resultHolder)
          Add a number of intervals to a datetime value.
 NumberDataValue timestampDiff(int intervalType, DateTimeDataValue time1, java.sql.Date currentDate, NumberDataValue resultHolder)
          Finds the difference between two datetime values as a number of intervals.
(package private) static void timeToString(int hour, int minute, int second, java.lang.StringBuffer sb)
          Convert a time to a JDBC escape format string
 java.lang.String toString()
           
private  SQLTimestamp toTimestamp(java.sql.Date currentDate)
           
 int typePrecedence()
          Each built-in type in JSQL has a precedence.
 void writeExternal(java.io.ObjectOutput out)
           
 
Methods inherited from class org.apache.derby.iapi.types.DataType
checkHostVariable, cloneObject, coalesce, dataTypeConversion, equals, equals, flip, genericSetObject, getBoolean, getByte, getBytes, getDate, getDouble, getFloat, getInt, getLong, getShort, getStream, greaterOrEquals, greaterThan, in, invalidFormat, isNotNull, isNullOp, lessOrEquals, lessThan, normalize, notEquals, outOfRange, setBigDecimal, setInto, setObjectForCast, setToNull, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, throwLangSetMismatch, throwLangSetMismatch, typeToBigDecimal
 
Methods inherited from class java.lang.Object
clone, finalize, getClass, notify, notifyAll, wait, wait, wait
 
Methods inherited from interface org.apache.derby.iapi.types.DataValueDescriptor
checkHostVariable, coalesce, equals, getBoolean, getByte, getBytes, getDate, getDouble, getFloat, getInt, getLong, getShort, getStream, greaterOrEquals, greaterThan, in, isNotNull, isNullOp, lessOrEquals, lessThan, normalize, notEquals, setBigDecimal, setInto, setObjectForCast, setToNull, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, typeToBigDecimal
 

Field Detail

encodedTime

private int encodedTime

encodedTimeFraction

private int encodedTimeFraction

valueString

private java.lang.String valueString

BASE_MEMORY_USAGE

private static final int BASE_MEMORY_USAGE

IBM_EUR_SEPARATOR

private static final char IBM_EUR_SEPARATOR
See Also:
Constant Field Values

IBM_EUR_SEPARATOR_OR_END

private static final char[] IBM_EUR_SEPARATOR_OR_END

JIS_SEPARATOR

static final char JIS_SEPARATOR
See Also:
Constant Field Values

US_OR_JIS_MINUTE_END

private static final char[] US_OR_JIS_MINUTE_END

ANY_SEPARATOR

private static final char[] ANY_SEPARATOR

AM_PM

private static final java.lang.String[] AM_PM

END_OF_STRING

private static final char[] END_OF_STRING
Constructor Detail

SQLTime

public SQLTime()
no-arg constructor required by Formattable


SQLTime

public SQLTime(java.sql.Time value)
        throws StandardException

SQLTime

private SQLTime(int encodedTime,
                int encodedTimeFraction)

SQLTime

public SQLTime(java.lang.String timeStr,
               boolean isJdbcEscape,
               LocaleFinder localeFinder)
        throws StandardException
Construct a time from a string. The allowed time formats are:
  1. old ISO and IBM European standard: hh.mm[.ss]
  2. IBM USA standard: hh[:mm] {AM | PM}
  3. JIS & current ISO: hh:mm[:ss]

Throws:
Standard - exception if the syntax is invalid or the value is out of range.
StandardException

SQLTime

public SQLTime(java.lang.String timeStr,
               boolean isJdbcEscape,
               LocaleFinder localeFinder,
               java.util.Calendar cal)
        throws StandardException
Construct a time from a string. The allowed time formats are:
  1. old ISO and IBM European standard: hh.mm[.ss]
  2. IBM USA standard: hh[:mm] {AM | PM}
  3. JIS & current ISO: hh:mm[:ss]

Throws:
Standard - exception if the syntax is invalid or the value is out of range.
StandardException
Method Detail

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 java.lang.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.

getEncodedTime

int getEncodedTime()

getTimestamp

public java.sql.Timestamp getTimestamp(java.util.Calendar cal)
                                throws StandardException
Description copied from interface: DataValueDescriptor
Gets the value in the data value descriptor as a java.sql.Timestamp. Throws an exception if the data value is not a Timestamp.

Specified by:
getTimestamp in interface DataValueDescriptor
Overrides:
getTimestamp in class DataType
Parameters:
cal - calendar for object creation
Returns:
The data value as a java.sql.Timestamp.
Throws:
StandardException - thrown on failure

getObject

public java.lang.Object getObject()
Description copied from interface: DataValueDescriptor
Gets the value in the data value descriptor as a Java Object. The type of the Object will be the Java object type corresponding to the data value's SQL type. JDBC defines a mapping between Java object types and SQL types - we will allow that to be extended through user type definitions. Throws an exception if the data value is not an object (yeah, right).

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 java.lang.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(java.io.ObjectOutput out)
                   throws java.io.IOException
Specified by:
writeExternal in interface java.io.Externalizable
Throws:
java.io.IOException - error writing data

readExternal

public void readExternal(java.io.ObjectInput in)
                  throws java.io.IOException
Specified by:
readExternal in interface java.io.Externalizable
Throws:
java.io.IOException - Thrown on error reading the object
See Also:
Externalizable.readExternal(java.io.ObjectInput)

readExternalFromArray

public void readExternalFromArray(ArrayInputStream in)
                           throws java.io.IOException
Description copied from interface: DataValueDescriptor
Read the DataValueDescriptor from the stream.

Initialize the data value by reading it's values from the ArrayInputStream. This interface is provided as a way to achieve possible performance enhancement when reading an array can be optimized over reading from a generic stream from readExternal().

Specified by:
readExternalFromArray in interface DataValueDescriptor
Parameters:
in - The array stream positioned at the beginning of the byte stream to read from.
Throws:
java.io.IOException - Usual error is if you try to read past limit on the stream.

getClone

public DataValueDescriptor getClone()
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.

Specified by:
getClone in interface DataValueDescriptor
Returns:
A clone of the DataValueDescriptor with the same initial value as this.
See Also:
DataValueDescriptor.getClone()

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(java.sql.ResultSet resultSet,
                                  int colNumber,
                                  boolean isNullable)
                           throws java.sql.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)
Returns:
Nothing.
Throws:
java.sql.SQLException - Thrown on error
StandardException - Thrown on error
See Also:
DataValueDescriptor.setValueFromResultSet(java.sql.ResultSet, int, boolean)

compare

public int compare(DataValueDescriptor other)
            throws StandardException
Orderable interface

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 failure
See Also:
Orderable

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
Throws:
StandardException - thrown on error

parseTime

private void parseTime(java.util.Date value)
                throws StandardException
Throws:
StandardException

parseTime

private void parseTime(java.lang.String timeStr,
                       boolean isJdbcEscape,
                       LocaleFinder localeFinder,
                       java.util.Calendar cal)
                throws StandardException
Throws:
StandardException

setValue

public void setValue(java.lang.Object theValue)
              throws StandardException
Description copied from interface: DataValueDescriptor
Set the value of this DataValueDescriptor to the given value

Specified by:
setValue in interface DataValueDescriptor
Overrides:
setValue in class DataType
Throws:
StandardException

setFrom

protected void setFrom(DataValueDescriptor theValue)
                throws StandardException
Overrides:
setFrom in class DataType
Throws:
StandardException

setValue

public void setValue(java.sql.Time value,
                     java.util.Calendar cal)
              throws StandardException
Description copied from interface: DataValueDescriptor
Set the value of this DataValueDescriptor.

Specified by:
setValue in interface DataValueDescriptor
Overrides:
setValue in class DataType
Parameters:
value - The Time value to set this DataValueDescriptor to
cal - The time zone from the calendar is used to construct the database time value
Returns:
This DataValueDescriptor
Throws:
StandardException - thrown on failure.
See Also:
DataValueDescriptor.setValue(java.lang.Object)

setValue

public void setValue(java.sql.Timestamp value,
                     java.util.Calendar cal)
              throws StandardException
Description copied from interface: DataValueDescriptor
Set the value of this DataValueDescriptor.

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
Returns:
This DataValueDescriptor
Throws:
StandardException - thrown on failure.
See Also:
DataValueDescriptor.setValue(java.lang.Object)

setValue

public void setValue(java.lang.String theValue)
              throws StandardException
Description copied from interface: DataValueDescriptor
Set the value of this DataValueDescriptor.

Specified by:
setValue in interface DataValueDescriptor
Overrides:
setValue in class DataType
Parameters:
theValue - The BigDecimal value to set this DataValueDescriptor to
Returns:
This DataValueDescriptor
Throws:
StandardException

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(org.apache.derby.iapi.types.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(org.apache.derby.iapi.types.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(org.apache.derby.iapi.types.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(org.apache.derby.iapi.types.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(org.apache.derby.iapi.types.NumberDataValue)

getSeconds

public NumberDataValue getSeconds(NumberDataValue result)
                           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:
result - 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(org.apache.derby.iapi.types.NumberDataValue)

toString

public java.lang.String toString()

hashCode

public int hashCode()

typePrecedence

public int typePrecedence()
Description copied from interface: DataValueDescriptor
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.

Specified by:
isNull in interface Storable
Returns:
Whether or not value is logically null.

getTime

public java.sql.Time getTime(java.util.Calendar cal)
Get the time value Since this is a JDBC object we use the JDBC definition we use the JDBC definition, see JDBC API Tutorial and Reference section 47.3.12 Date is set to Jan. 1, 1970

Specified by:
getTime in interface DataValueDescriptor
Overrides:
getTime in class DataType
Parameters:
cal - calendar for object creation
Returns:
The localized time value.

newTime

protected java.sql.Time newTime(java.util.Calendar cal)

getHour

protected static int getHour(int encodedTime)
Get the encoded hour value (may be different than hour value for current timezone if value encoded in a different timezone)

Returns:
hour value

getMinute

protected static int getMinute(int encodedTime)
Get the encoded minute value (may be different than the minute value for current timezone if value encoded in a different timezone)

Returns:
minute value

getSecond

protected static int getSecond(int encodedTime)
Get the encoded second value (may be different than the second value for current timezone if value encoded in a different timezone)

Returns:
second value

computeEncodedTime

static int computeEncodedTime(java.util.Calendar cal)
                       throws StandardException
Calculate the encoded time from a Calendar object encoded time is hour << 16 + min << 8 + sec this function is also used by SQLTimestamp

Returns:
encoded time
Throws:
StandardException - if the time is not in the DB2 range

computeEncodedTime

static int computeEncodedTime(int hour,
                              int minute,
                              int second)
                       throws StandardException
Throws:
StandardException

timeToString

static void timeToString(int hour,
                         int minute,
                         int second,
                         java.lang.StringBuffer sb)
Convert a time to a JDBC escape format string

Parameters:
hour -
minute -
second -
sb - The resulting string is appended to this StringBuffer

encodedTimeToString

protected static java.lang.String encodedTimeToString(int encodedTime)
Get the String version from the encodedTime.

Returns:
string value.

getNationalString

protected java.lang.String getNationalString(LocaleFinder localeFinder)
                                      throws StandardException
International version of getString(). Overrides getNationalString in DataType for date, time, and timestamp.

Overrides:
getNationalString in class DataType
Throws:
StandardException - Thrown on error

computeEncodedTime

private int computeEncodedTime(java.util.Date value)
                        throws StandardException
Compute encoded time value Time is represented by hour << 16 + minute << 8 + seconds

Throws:
StandardException

computeEncodedTime

static int computeEncodedTime(java.util.Date value,
                              java.util.Calendar currentCal)
                       throws StandardException
Throws:
StandardException

setInto

public void setInto(java.sql.PreparedStatement ps,
                    int position)
             throws java.sql.SQLException,
                    StandardException
Adding this method to ensure that super class' setInto method doesn't get called that leads to the violation of JDBC spec( untyped nulls ) when batching is turned on.

Specified by:
setInto in interface DataValueDescriptor
Overrides:
setInto in class DataType
Throws:
java.sql.SQLException
StandardException

timestampAdd

public DateTimeDataValue timestampAdd(int intervalType,
                                      NumberDataValue intervalCount,
                                      java.sql.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
intervalCount - 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

toTimestamp

private SQLTimestamp toTimestamp(java.sql.Date currentDate)
                          throws StandardException
Throws:
StandardException

timestampDiff

public NumberDataValue timestampDiff(int intervalType,
                                     DateTimeDataValue time1,
                                     java.sql.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

Built on Tue 2006-10-10 19:23:47+0200, from revision exported

Apache Derby V10.1 Engine Documentation - Copyright © 1997,2005 The Apache Software Foundation or its licensors, as applicable.