Results for TO_DATE


1 to 20 of 161 results. Prev  Next
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 … . Do not use the TO_DATE function with a DATE value for the char argument. The first two digits of the … into a date: SELECT TO_DATE( 'January 15, 1989, 11:00 A.M.', 'Month dd, YYYY, HH:MI A.M … .',

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

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, 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);

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

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

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')\";

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.

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

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

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

Concepts, 9i Release 2 (9.2.0.2)

Partitioned Tables and Indexes

Partitioned Index ExamplesTABLESPACE tabsp_overflow PARTITION BY RANGE(sales_date) (PARTITION sales_jan2000 VALUES LESS THAN(TO_DATE … THAN(TO_DATE('03/01/2000','DD/MM/YYYY')) OVERFLOW TABLESPACE p2_overflow, PARTITION sales_mar2000 … VALUES LESS THAN(TO_DATE('04/01/2000','DD/MM/YYYY')) OVERFLOW TABLESPACE p3_overflow, PARTITION … sales_apr2000 VALUES

Concepts, 9i Release 2 (9.2.0.2)

Partitioned Tables and Indexes

Range PartitioningBY RANGE(sales_date) ( PARTITION sales_jan2000 VALUES LESS THAN(TO_DATE('02/01/2000','DD/MM/YYYY … ')), PARTITION sales_feb2000 VALUES LESS THAN(TO_DATE('03/01/2000','DD/MM/YYYY')), PARTITION … sales_mar2000 VALUES LESS THAN(TO_DATE('04/01/2000','DD/MM/YYYY')), PARTITION sales_apr2000 VALUES LESS THAN(TO_DATE('05/01/2000','DD/MM/YYYY'))


Was this page helpful?