|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
Field Summary | |
static int |
DAY_FIELD
|
static int |
DAY_INTERVAL
|
static int |
FRAC_SECOND_INTERVAL
|
static int |
HOUR_FIELD
|
static int |
HOUR_INTERVAL
|
static int |
MINUTE_FIELD
|
static int |
MINUTE_INTERVAL
|
static int |
MONTH_FIELD
|
static int |
MONTH_INTERVAL
|
static int |
QUARTER_INTERVAL
|
static int |
SECOND_FIELD
|
static int |
SECOND_INTERVAL
|
static int |
WEEK_INTERVAL
|
static int |
YEAR_FIELD
|
static int |
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 |
Method Summary | |
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. |
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. |
NumberDataValue |
getSeconds(NumberDataValue result)
Get the second of the minute out of a time or timestamp. |
NumberDataValue |
getYear(NumberDataValue result)
Get the year number out of a date. |
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. |
Methods inherited from interface org.apache.derby.iapi.types.DataValueDescriptor |
checkHostVariable, coalesce, compare, compare, equals, estimateMemoryUsage, getBoolean, getByte, getBytes, getClone, getDate, getDouble, getFloat, getInt, getLength, getLong, getNewNull, getObject, getShort, getStream, getString, getTime, getTimestamp, getTypeName, greaterOrEquals, greaterThan, in, isNotNull, isNullOp, lessOrEquals, lessThan, normalize, notEquals, readExternalFromArray, setBigDecimal, setInto, setInto, setObjectForCast, setToNull, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValueFromResultSet, typePrecedence, typeToBigDecimal |
Methods inherited from interface org.apache.derby.iapi.services.io.Storable |
isNull, restoreToNull |
Methods inherited from interface java.io.Externalizable |
readExternal, writeExternal |
Methods inherited from interface org.apache.derby.iapi.services.io.TypedFormat |
getTypeFormatId |
Field Detail |
public static final int YEAR_FIELD
public static final int MONTH_FIELD
public static final int DAY_FIELD
public static final int HOUR_FIELD
public static final int MINUTE_FIELD
public static final int SECOND_FIELD
public static final int FRAC_SECOND_INTERVAL
public static final int SECOND_INTERVAL
public static final int MINUTE_INTERVAL
public static final int HOUR_INTERVAL
public static final int DAY_INTERVAL
public static final int WEEK_INTERVAL
public static final int MONTH_INTERVAL
public static final int QUARTER_INTERVAL
public static final int YEAR_INTERVAL
Method Detail |
public NumberDataValue getYear(NumberDataValue result) throws StandardException
result
- The result of the previous call to this method, null
if not called yet.
StandardException
- Thrown on errorpublic NumberDataValue getMonth(NumberDataValue result) throws StandardException
result
- The result of the previous call to this method, null
if not called yet.
StandardException
- Thrown on errorpublic NumberDataValue getDate(NumberDataValue result) throws StandardException
result
- The result of the previous call to this method, null
if not called yet.
StandardException
- Thrown on errorpublic NumberDataValue getHours(NumberDataValue result) throws StandardException
result
- The result of the previous call to this method, null
if not called yet.
StandardException
- Thrown on errorpublic NumberDataValue getMinutes(NumberDataValue result) throws StandardException
result
- The result of the previous call to this method, null
if not called yet.
StandardException
- Thrown on errorpublic NumberDataValue getSeconds(NumberDataValue result) throws StandardException
result
- The result of the previous call to this method, null
if not called yet.
StandardException
- Thrown on errorpublic DateTimeDataValue timestampAdd(int intervalType, NumberDataValue intervalCount, java.sql.Date currentDate, DateTimeDataValue resultHolder) throws StandardException
intervalType
- One of FRAC_SECOND_INTERVAL, SECOND_INTERVAL, MINUTE_INTERVAL, HOUR_INTERVAL,
DAY_INTERVAL, WEEK_INTERVAL, MONTH_INTERVAL, QUARTER_INTERVAL, or YEAR_INTERVALintervalCount
- The number of intervals to addcurrentDate
- Used to convert time to timestampresultHolder
- If non-null a DateTimeDataValue that can be used to hold the result. If null then
generate a new holder
StandardException
public NumberDataValue timestampDiff(int intervalType, DateTimeDataValue time1, java.sql.Date currentDate, NumberDataValue resultHolder) throws StandardException
intervalType
- One of FRAC_SECOND_INTERVAL, SECOND_INTERVAL, MINUTE_INTERVAL, HOUR_INTERVAL,
DAY_INTERVAL, WEEK_INTERVAL, MONTH_INTERVAL, QUARTER_INTERVAL, or YEAR_INTERVALtime1
- currentDate
- Used to convert time to timestampresultHolder
- If non-null a DateTimeDataValue that can be used to hold the result. If null then
generate a new holder
StandardException
|
Built on Mon 2007-06-04 09:58:47+0400, from revision ??? | |||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |