public interface DateTimeDataValue extends DataValueDescriptor
Modifier and Type | Field and Description |
---|---|
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 |
UNKNOWN_LOGICAL_LENGTH
ORDER_OP_EQUALS, ORDER_OP_GREATEROREQUALS, ORDER_OP_GREATERTHAN, ORDER_OP_LESSOREQUALS, ORDER_OP_LESSTHAN
Modifier and Type | Method and Description |
---|---|
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.
|
checkHostVariable, cloneHolder, cloneValue, coalesce, compare, compare, compare, compare, equals, estimateMemoryUsage, getBoolean, getByte, getBytes, getDate, getDouble, getFloat, getInt, getLength, getLong, getNewNull, getObject, getShort, getStream, getString, getTime, getTimestamp, getTraceString, getTypeName, greaterOrEquals, greaterThan, hasStream, in, isNotNull, isNullOp, lessOrEquals, lessThan, normalize, notEquals, readExternalFromArray, recycle, setBigDecimal, setInto, setInto, setObjectForCast, setToNull, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValue, setValueFromResultSet, typePrecedence, typeToBigDecimal
isNull, restoreToNull
getTypeFormatId
static final int YEAR_FIELD
static final int MONTH_FIELD
static final int DAY_FIELD
static final int HOUR_FIELD
static final int MINUTE_FIELD
static final int SECOND_FIELD
static final int FRAC_SECOND_INTERVAL
static final int SECOND_INTERVAL
static final int MINUTE_INTERVAL
static final int HOUR_INTERVAL
static final int DAY_INTERVAL
static final int WEEK_INTERVAL
static final int MONTH_INTERVAL
static final int QUARTER_INTERVAL
static final int YEAR_INTERVAL
NumberDataValue getYear(NumberDataValue result) throws StandardException
result
- The result of the previous call to this method, null
if not called yet.StandardException
- Thrown on errorNumberDataValue getMonth(NumberDataValue result) throws StandardException
result
- The result of the previous call to this method, null
if not called yet.StandardException
- Thrown on errorNumberDataValue getDate(NumberDataValue result) throws StandardException
result
- The result of the previous call to this method, null
if not called yet.StandardException
- Thrown on errorNumberDataValue getHours(NumberDataValue result) throws StandardException
result
- The result of the previous call to this method, null
if not called yet.StandardException
- Thrown on errorNumberDataValue getMinutes(NumberDataValue result) throws StandardException
result
- The result of the previous call to this method, null
if not called yet.StandardException
- Thrown on errorNumberDataValue getSeconds(NumberDataValue result) throws StandardException
result
- The result of the previous call to this method, null
if not called yet.StandardException
- Thrown on errorDateTimeDataValue 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 holderStandardException
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 holderStandardException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.