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 1790 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Reference Guide for Informix Dynamic Server Migrations, 9i Release 2 (9.2.0.2)

Oracle and Informix Dynamic Server Compared

DATEThe DATE datatype stores the calendar date and the default display format is mm/dd/yyyy where mm is … the month (01-12), dd is the day of the month (01-31) and yyyy is the year (0001-9999). The DATE … values are stored as integers thus DATE can be used in arithmetic expressions. For example … , subtracting a DATE

Programmer's Guide, 9i Release 2 (9.2.0.2)

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

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Selecting a Datatype

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

Administrator's Guide, 9i Release 2 (9.2.0.2)

Events

Date/TimeThe date and time when the comment was entered.

Administrator's Guide, 9i Release 2 (9.2.0.2)

Events

Date/TimeThe date and time of the notification.

Supplied Java Packages Reference, 9i Release 2 (9.2.0.2)

Package oracle.xdb.spi

setLastModDate(Date)Description Sets the last modification date of the resource Syntax public void setLastModDate … (java.util.Date d) Parameters d - last modification date of the resource

Supplied Java Packages Reference, 9i Release 2 (9.2.0.2)

Package oracle.xdb.spi

setCreateDate(Date)Description Sets the creation date of the resource Syntax public void setCreateDate(java.util.Date … credate) Parameters credate - creation date of the resource

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 155 of 177

TRUNC (date)Syntax trunc_date::= Text description of trunc_date Purpose The TRUNC (date) function returns date … omit fmt, then date is truncated to the nearest day. See Also: "ROUND and TRUNC Date Functions" for the … permitted format models to use in fmt Examples The following example truncates a date: SELECT

Oracle® C++ Call Interface Programmer's Guide, 9i Release 2 (9.2.0.2)

OCCI Classes and Methods, 8 of 22

Date ClassThe 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 both. To create a Date

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Datatype Mapping and Manipulation Functions, 47 of 134

date (IN)Oracle datetime value to be converted

Administrator's Guide, 9i Release 2 (9.2.0.2)

Jobs

Date/TimeThis is the time the Management Server was notified by the Intelligent Agent that a status change had occurred. Job Output Dialog Box The Output dialog box is displayed by double-clicking on an entry in the Progress page, or selecting an entry and clicking on the Show Output button, if enabled. This dialog displays any output, including error messages, as a result of the execution of an occurrence

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Datatype Mapping and Manipulation Functions, 19 of 134

date (IN)Date to be checked

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Datatype Mapping and Manipulation Functions, 17 of 134

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

Programmer's Guide, 9i Release 2 (9.2.0.2)

Object-Relational Datatypes

Date Example/* tim is pointing to the pinned object. */ /* set the start date of tim */ OCIDateSetTime(&tim … ->start_date,8,0,0); OCIDateSetDate(&tim->start_date,1990,10,5) /* check if the date is valid */ if … ->start_date, &last_day) != OCI_SUCCESS) /* error handling code */ /* get date of next named day */ if … the date

Administrator's Guide, 9i Release 2 (9.2.0.2)

Events

Date/TimeTime and date of the event occurrence.

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Datatype Mapping and Manipulation Functions, 25 of 134

date (IN)Input date.

Concepts, 9i Release 2 (9.2.0.2)

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

Administrator's Guide, 9i Release 2 (9.2.0.2)

Events

Date/TimeDate and Time the event was submitted for registration.

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Datatype Mapping and Manipulation Functions, 22 of 134

date (OUT)Given string converted to date.

Administrator's Guide, 9i Release 2 (9.2.0.2)

Jobs

Date/TimeThis is the time the Intelligent Agent returns after the job has been scheduled by the Intelligent Agent. Context-sensitive Menu options The following options are available by selecting a job and clicking the right mouse button.