You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for DATE


1 to 20 of 2456 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


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

3 Datatypes

DATEThe DATE datatype can update, insert, or retrieve a date value using the Oracle internal date … binary format. A date in binary format contains seven bytes, as shown in Table 3-4. Table 3-4 Format of … the DATE Datatype Byte 1 2 3 4 5 6 7 Meaning Century Year Month Day Hour Minute Second Example (for

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

Date C l ass

Date()Date class constructor. Syntax Description Date(); Creates a NULL Date object. Date( const Date … &srcDate); Create a copy of a Date object. Date( const Environment *envp, int year = 1, unsigned int … = 0); Create a Date object using integer parameters.

SQL Reference, 10g Release 1 (10.1)

TRUNC (date)

TRUNC (date)Syntax trunc_date::= Description of the illustration trunc_date.gif Purpose The TRUNC (date … ) function returns date with the time portion of the day truncated to the unit specified by the format model … fmt. The value returned is always of datatype DATE, even if you specify a different datetime … datatype for date.

SQL Reference, 10g Release 1 (10.1)

ROUND (date)

ROUND (date)Syntax round_date::= Description of the illustration round_date.gif Purpose ROUND returns date … rounded to the unit specified by the format model fmt. The value returned is always of datatype DATE … , even if you specify a different datetime datatype for date. If you omit fmt, then date is rounded to … the nearest

DML Reference, 10g Release 1 (10.1)

YYOF

date-expressionAn expression that has the DATE data type, or a text expression that specifies a date. See "TEXT-to … -DATE Conversion". Notes TEXT-to-DATE Conversion In place of a date expression, you can specify a … converts the values of the text expression to DATE values, using the current setting

Database, 10g Release 1 (10.1)

Apache Tutorial: Introduction to Server Side Includes

Today's datecan define your own variables with the set element. If you don't like the format in which the date

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

OCI Date, Datetime, and Interval Functions

date (IN)The date to be checked.

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

11 Object-Relational Datatypes in OCI

Date (OCIDate)The Oracle date format is mapped in C by the OCIDate type, which is an opaque C struct. Elements of … the struct represent the year, month, day, hour, minute, and second of the date. The specific … otherwise specified, the term date in these function calls refers to a value of type OCIDate. See Also: The

DML Reference, 10g Release 1 (10.1)

DDOF

date-expressionAn expression that has the DATE data type, or a text expression that specifies a date. See "TEXT-to … -DATE Conversion". Notes TEXT-to-DATE Conversion In place of a DATE expression, you can specify a … expressions are automatically converted to DATE values using the current setting of

DML Reference, 10g Release 1 (10.1)

MMOF

date-expressionAn expression that has the DATE data type, or a text expression that specifies a date. See "TEXT-to … -DATE Conversion". Notes TEXT-to-DATE Conversion In place of a DATE expression, you can specify a … expression are converted automatically to DATE values, using the current setting of

DML Reference, 10g Release 1 (10.1)

DAYOF

date-expressionAn expression that has the DATE data type, or a text expression that specifies a date. See "TEXT-to … -DATE Conversion". Notes TEXT-to-DATE Conversion In place of a DATE expression, you can specify a … converts the values of the text expression to DATE values, using the current setting

Concepts, 10g Release 1 (10.1)

26 Native Datatypes

Date ArithmeticOracle date arithmetic takes into account the anomalies of the calendars used throughout history … into the database, but they are ignored in date arithmetic and treated as the next "real" date. For … -1582. Note: This discussion of date arithmetic might not apply to all countries' date standards (such

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

2 Selecting a Datatype

Date FormatFor input and output of dates, the standard Oracle Database default date format is DD-MON-RR. For … example: '13-NOV-92' To change this default date format on an instance-wide basis, use the … dates that are not in the current default date format, use the TO_DATE function with a format mask … generated by other date

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

OCI Date, Datetime, and Interval Functions

date (IN)The given date from which to add or subtract.

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

OCI Date, Datetime, and Interval Functions

date (OUT)Given string converted to date.

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

OCI Date, Datetime, and Interval Functions

date (IN)Returned date should be later than this date.

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

OCI Date, Datetime, and Interval Functions

date (IN)Oracle datetime value to be converted

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

Date C l ass

Date ClassDate C lass The Date class specifies the abstraction for a SQL DATE data item. The Date class also … adds formatting and parsing operations to support the OCCI escape syntax for date values. Since … SQL92 DATE is a subset of Oracle Date, this class can be used to support

DML Reference, 10g Release 1 (10.1)

WEEKOF

date-expressionAn expression that has the DATE data type, or a text expression that specifies a date. See "TEXT-to … -DATE Conversion". Notes TEXT-to-DATE Conversion In place of a DATE expression, you can specify a … converts the values of the text expression to DATE values, using the current setting

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

OCI Date, Datetime, and Interval Functions

date (IN)The given date from which to add or subtract.