Results for INTERVAL


1 to 20 of 1177 results. Prev  Next
Results per page:   20  | 40 | 60


SQL Reference, 10g Release 1 (10.1)

Interval Expressions

Interval ExpressionsAn interval expression yields a value of INTERVAL YEAR TO MONTH or INTERVAL DAY TO SECOND … be the value of an INTERVAL column or a compound expression that yields an interval value. Datetimes … yield interval values are valid in an interval expression. Both leading_field_precision

Programmer's Guide, 10g Release 1 (10.1)

OCI Date, Datetime, and Interval Functions

interval (IN)Interval to be checked.

SQL Reference, 10g Release 1 (10.1)

Literals

Interval LiteralsAn interval literal specifies a period of time. You can specify these differences in terms of years … interval literals, YEAR TO MONTH and DAY TO SECOND. Each type contains a leading field and may … TO MONTH interval considers an interval of years to the nearest month. A DAY TO MINUTE interval

Packages and Types Reference, 10g Release 1 (10.1)

41 DBMS_JOB

INTERVAL ProcedureThis procedure changes how often a job runs.

Programmer's Guide, 10g Release 1 (10.1)

OCI Date, Datetime, and Interval Functions

interval (IN)The input interval.

Programmer's Guide, 10g Release 1 (10.1)

OCI Date, Datetime, and Interval Functions

interval (OUT)Interval result.

Programmer's Guide, 10g Release 1 (10.1)

OCI Date, Datetime, and Interval Functions

interval (IN)Interval to be converted.

Programmer's Guide, 10g Release 1 (10.1)

11 Object-Relational Datatypes in OCI

Interval FunctionsThe following functions operate exclusively on interval data. In some cases it is necessary to … specify the type of interval involved. Possible types include: SQLT_INTERVAL_YM - interval year to month … SQLT_INTERVAL_DS - interval day to second See the individual function descriptions for more … information about

Programmer's Guide, 10g Release 1 (10.1)

OCI Date, Datetime, and Interval Functions

interval (IN)Interval to be converted.

Programmer's Guide, 10g Release 1 (10.1)

OCI Date, Datetime, and Interval Functions

interval (IN)The input interval.

Globalization Support Guide, 10g Release 1 (10.1)

4 Datetime Datatypes and Time Zone Support

Interval DatatypesInterval datatypes store time durations. They are used primarily with analytic functions. For … example, you can use them to calculate a moving average of stock prices. You must use interval datatypes … to determine the values that correspond to a particular percentile. You can also use interval … datatypes to update historical

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Interval Y M Class

operator-()interval to be compared. second The second interval to be compared.

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Interval Y M Class

setNull()This method sets the interval to NULL. Syntax void setNull();

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Interval Y M Class

getYear()This method returns the year component of the interval. Syntax int getYear() const;

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Interval Y M Class

operator+()IntervalYM &first, const IntervalYM &second); Parameter Description first The first interval to be compared. second The second interval to be compared.

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Interval Y M Class

operator*()This method multiplies the interval by a factor and returns the result. Syntax const IntervalYM … operator*( const IntervalDS &interval const Number &value); Parameter Description interval Interval to … be multiplied. val Value by which interval is to be multiplied.

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Interval Y M Class

operator=()This method assigns the specified value to the interval. Syntax const IntervalYM& operator=( const

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Interval Y M Class

operator<()operatorbool operator Parameter Description first The first interval to be compared. second The second interval to be compared.

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Interval Y M Class

fromText()This method initializes the interval to the values in inpstr. The string is interpreted using the … ); Parameter Description inpStr Input string representing a year month interval of the form 'year-month

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

Interval Y M Class

toText()This method returns the string representation of the interval. Syntax string toText( unsigned int


Was this page helpful?