DateTimeDataValue

Overview

Package

Class

Use

Deprecated

Index

Home >> All >> org >> apache >> derby >> iapi >> [ types overview ]

PREV CLASS NEXT CLASS

SUMMARY:

JAVADOC |

Sourc code of org.apache.derby.iapi.types.DateTimeDataValue

SOURCE |

Download org.apache.derby.iapi.types.DateTimeDataValue

DOWNLOAD | NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

org.apache.derby.iapi.types
Interface DateTimeDataValue

All Superinterfaces:: DataValueDescriptor, java.io.Externalizable, org.apache.derby.iapi.services.io.Formatable, Orderable, java.io.Serializable, org.apache.derby.iapi.services.io.Storable, org.apache.derby.iapi.services.io.TypedFormat

All Known Implementing Classes:: SQLDate, SQLTime, SQLTimestamp

public interface DateTimeDataValue
extends DataValueDescriptor

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

YEAR_FIELD

public static final int YEAR_FIELD

See Also:: Constant Field Values

MONTH_FIELD

public static final int MONTH_FIELD

See Also:: Constant Field Values

DAY_FIELD

public static final int DAY_FIELD

See Also:: Constant Field Values

HOUR_FIELD

public static final int HOUR_FIELD

See Also:: Constant Field Values

MINUTE_FIELD

public static final int MINUTE_FIELD

See Also:: Constant Field Values

SECOND_FIELD

public static final int SECOND_FIELD

See Also:: Constant Field Values

FRAC_SECOND_INTERVAL

public static final int FRAC_SECOND_INTERVAL

See Also:: Constant Field Values

SECOND_INTERVAL

public static final int SECOND_INTERVAL

See Also:: Constant Field Values

MINUTE_INTERVAL

public static final int MINUTE_INTERVAL

See Also:: Constant Field Values

HOUR_INTERVAL

public static final int HOUR_INTERVAL

See Also:: Constant Field Values

DAY_INTERVAL

public static final int DAY_INTERVAL

See Also:: Constant Field Values

WEEK_INTERVAL

public static final int WEEK_INTERVAL

See Also:: Constant Field Values

MONTH_INTERVAL

public static final int MONTH_INTERVAL

See Also:: Constant Field Values

QUARTER_INTERVAL

public static final int QUARTER_INTERVAL

See Also:: Constant Field Values

YEAR_INTERVAL

public static final int YEAR_INTERVAL

See Also:: Constant Field Values

Method Detail

getYear

public NumberDataValue getYear(NumberDataValue result)
                        throws org.apache.derby.iapi.error.StandardException

Get the year number out of a date.

getMonth

public NumberDataValue getMonth(NumberDataValue result)
                         throws org.apache.derby.iapi.error.StandardException

Get the month number out of a date.

getDate

public NumberDataValue getDate(NumberDataValue result)
                        throws org.apache.derby.iapi.error.StandardException

Get the day of the month.

getHours

public NumberDataValue getHours(NumberDataValue result)
                         throws org.apache.derby.iapi.error.StandardException

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

getMinutes

public NumberDataValue getMinutes(NumberDataValue result)
                           throws org.apache.derby.iapi.error.StandardException

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

getSeconds

public NumberDataValue getSeconds(NumberDataValue result)
                           throws org.apache.derby.iapi.error.StandardException

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

timestampAdd

public DateTimeDataValue timestampAdd(int intervalType,
                                      NumberDataValue intervalCount,
                                      java.sql.Date currentDate,
                                      DateTimeDataValue resultHolder)
                               throws org.apache.derby.iapi.error.StandardException

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

timestampDiff

public NumberDataValue timestampDiff(int intervalType,
                                     DateTimeDataValue time1,
                                     java.sql.Date currentDate,
                                     NumberDataValue resultHolder)
                              throws org.apache.derby.iapi.error.StandardException

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