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 TO_DATE


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


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 137 of 177

TO_DATESyntax to_date::= Text description of to_date Purpose TO_DATE converts char of CHAR, VARCHAR2 … not use the TO_DATE function with a DATE value for the char argument. The first two digits of the … date: SELECT TO_DATE( 'January 15, 1989, 11:00 A.M.', 'Month dd, YYYY, HH:MI A.M … .', 'NLS_DATE_LANGUAGE

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

TO_CLOBTO_DATE TO_DSINTERVAL

Error Messages, 9i Release 2 (9.2.0.2)

ORA-02100 to ORA-04099

ORA-02470 TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.Cause: TO_DATE, USERENV and SYSDATE are not allowed in hash expressions. Action: Re-create the cluster and correct the error in hash expression.

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

OCI Datatype Mapping and Manipulation Functions, 37 of 134

CommentsRefer to the description of the TO_DATE conversion function in the Oracle8 i or later SQL Reference for a description of the format argument.

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

Using LogMiner to Analyze Redo Logs

Filtering Data By Time… Use the TO_DATE function to specify date and time, as in this example: SQL> EXECUTE … DBMS_LOGMNR.START_LOGMNR( - 2 DICTFILENAME => '/oracle/dictionary.ora', - 3 STARTTIME => TO_DATE('01-Jan-1998 08 … :30:00', 'DD-MON-YYYY HH:MI:SS'), - 4 ENDTIME => TO_DATE('01-Jan-1998 08:45:00', 'DD-MON-YYYY HH:MI:SS

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

OCI Datatype Mapping and Manipulation Functions, 47 of 134

CommentsRefer to the description of the TO_DATE conversion function in the Oracle9 i or later SQL Reference

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_REPCAT_RGT, 2 of 2

SyntaxDATE:= to_date('1', 'J'), new_modified_by IN NUMBER:= -1e-130);

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_REPCAT_RGT

SyntaxDATE:= to_date('1', 'J'), new_modified_by IN NUMBER:= -1e-130);

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

OCI Datatype Mapping and Manipulation Functions, 22 of 134

CommentsRefer to the TO_DATE conversion function described in the Oracle9i SQL Reference for a description

Utilities, 9i Release 2 (9.2.0.2)

SQL*Loader Case Studies

Table Creationship_q1 values less than (TO_DATE('01-APR-1996', 'DD-MON-YYYY')) tablespace p01, partition ship_q2 values … less than (TO_DATE('01-JUL-1996', 'DD-MON-YYYY')) tablespace p02, partition ship_q3 values less … than (TO_DATE('01-OCT-1996', 'DD-MON-YYYY')) tablespace p03, partition ship_q4 values less than (TO_DATE('01-JAN-1997',

Globalization Support Guide, 9i Release 2 (9.2.0.2)

SQL and PL/SQL Programming in a Global Environment

Unacceptable NLS Parameters in SQL FunctionsTO_CHAR or TO_DATE function. As a result, NLS_DATE_FORMAT is not a valid NLS parameter for the TO_CHAR or … TO_DATE functions. If NLS_LANGUAGE or NLS_TERRITORY is specified in the TO_CHAR, TO_NUMBER, or … TO_DATE functions, then a format mask must also be specified as the second parameter of the function

Data Warehousing Guide, 9i Release 2 (9.2.0.2)

Materialized Views

Partitioning a Materialized View) (PARTITION month1 VALUES LESS THAN (TO_DATE('31-12-1998', 'DD-MM-YYYY')) PCTFREE 0 PCTUSED 99 STORAGE … (INITIAL 64k NEXT 16k PCTINCREASE 0) TABLESPACE sf1, PARTITION month2 VALUES LESS THAN (TO_DATE('31-12-1999 … , PARTITION month3 VALUES LESS THAN (TO_DATE('31-12-2000', 'DD-MM-YYYY')) PCTFREE 0 PCTUSED 99 STORAGE

Recovery Manager Reference, 9i Release 2 (9.2.0.2)

RMAN Commands, 57 of 59

Restrictions and Usage Notes"TO_DATE('01/30/1997', 'MM/DD/YYYY')". Note that the second example includes its own date format … '; RESTORE DATABASE UNTIL TIME "TO_DATE('09/20/00','MM/DD/YY')";

Recovery Manager Reference, 9i Release 2 (9.2.0.2)

RMAN Commands, 14 of 59

Restrictions and Usage Notesexamples: ' SYSDATE-30 ' TO_DATE('09/30/2000 08:00:00','MM/DD/YY HH24:MI:SS'). The TO_DATE

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Datatypes

DATE ValuesVARCHAR2 value into a DATE column. So, PL/SQL calls the function TO_DATE, which expects the default date … format. To insert dates in other formats, you must call TO_DATE with a format mask.

Reference, 9i Release 2 (9.2.0.2)

Initialization Parameters, 117 of 222

NLS_DATE_LANGUAGE… , p.m., AD, BC) returned by the TO_DATE and TO_CHAR functions. See Also: Oracle9i Database … information on the TO_DATE and TO_CHAR functions. Oracle9i Heterogeneous Connectivity Administrator's Guide

Sample Schemas, 9i Release 2 (9.2.0.2)

Oracle9i Sample Schema Scripts

sh_cre.sql() attributes have to be converted REM with the appropriate TO_DATE() function REM time_id /* day date … LESS THAN (TO_DATE('01-JAN-1996','DD-MON-YYYY','NLS_DATE_LANGUAGE = American')), PARTITION SALES_1996 … VALUES LESS THAN (TO_DATE('01-JAN-1997','DD-MON-YYYY','NLS_DATE_LANGUAGE = American')), PARTITION … SALES_H1_1997 VALUES

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Error Messages

CPY0005 Source and destination column attributes don't matchwith the destination. Use TO_DATE, TO_CHAR, and TO_NUMBER to make conversions.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Datatypes

Explicit Conversiona CHAR value to a DATE or NUMBER value, you use the function TO_DATE or TO_NUMBER, respectively

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

Modeling and Design

Adding Partitions to Tables Containing LOB DataTABLE PresidentPhoto_tab ADD PARTITION RichardNixon2_part VALUES LESS THAN (TO_DATE('20-jan-1976