Results for TO_DATE


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


SQL Reference, 10g Release 1 (10.1)

TO_DATE

TO_DATESyntax to_date::= Description of the illustration to_date.gif Purpose TO_DATE converts char of CHAR … function for date conversion. Do not use the TO_DATE function with a DATE value for the char argument … character string into a date: SELECT TO_DATE( 'January 15, 1989, 11:00 A.M.', 'Month dd, YYYY, HH:MI A.M

DML Reference, 10g Release 1 (10.1)

TO_DATE

text-expoptions that set other options. See "Specifying Options". Notes Similarity to SQL TO_DATE Function The … OLAP DML TO_DATE function has the same functionality as the SQL TO_DATE function. For more … information about the SQL TO_DATE function, see Oracle Database SQL Reference. Capitalization Capital letters … day

DML Reference, 10g Release 1 (10.1)

TO_DATE

TO_DATEThe TO_DATE function converts a formatted TEXT or NTEXT expression to a DATETIME value. This … TO_DATE( text-exp, [ fmt,] [ option setting ]) Arguments

Error Messages, 10g Release 1 (10.1)

5 ORA-02140 to ORA-04099

ORA-02470: TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.and correct the error in hash expression. ORA-02470: TO_DATE, USERENV, or SYSDATE incorrectly used in hash expression.

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

3 Workspace Manager Valid Time Support

3.5.8 WM_OVERLAPSperiods p1 and p2 overlap; otherwise, it returns 0. For example: WM_OVERLAPS(TO_DATE('01-01-1980', 'MM-DD … -YYYY'), TO_DATE('01-01-1990', 'MM-DD-YYYY') TO_DATE('01-01-1985', 'MM-DD-YYYY'), TO_DATE('01-01-1995 … ', 'MM-DD-YYYY') = 1 WM_OVERLAPS(TO_DATE('01-01-1980', 'MM-DD-YYYY'), TO_DATE('01-01-1990',

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

OCI Date, Datetime, and Interval Functions

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

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

3 Workspace Manager Valid Time Support

3.5.4 WM_INTERSECTIONperiod between 01-Jan-1985 to 01-Jan-1988: WM_INTERSECTION(TO_DATE('01-01-1980', 'MM-DD-YYYY'), TO_DATE … ('01-01-1990', 'MM-DD-YYYY') TO_DATE('01-01-1985', 'MM-DD-YYYY'), TO_DATE('01-01-1988', 'MM-DD-YYYY … (TO_DATE('01-01-1980', 'MM-DD-YYYY'), TO_DATE('01-01-1990', 'MM-DD-YYYY') TO_DATE('01-01-1985',

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

3 Workspace Manager Valid Time Support

3.5.5 WM_LDIFFleft. The following example returns the period between 01-Jan-1980 to 01-Jan-1985: WM_LDIFF(TO_DATE … ('01-01-1980', 'MM-DD-YYYY'), TO_DATE('01-01-1990', 'MM-DD-YYYY') TO_DATE('01-01-1985', 'MM-DD-YYYY … '), TO_DATE('01-01-1988', 'MM-DD-YYYY') The following example returns a value because p1 … .validFrom is greater

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

3 Workspace Manager Valid Time Support

3.5.2 WM_EQUALSreturns 0. For example: WM_EQUALS(TO_DATE('01-01-1980', 'MM-DD-YYYY'), TO_DATE('01-01-1990', 'MM-DD … -YYYY') TO_DATE('01-01-1980', 'MM-DD-YYYY'), TO_DATE('01-01-1990', 'MM-DD-YYYY') = 1 WM_EQUALS(TO_DATE … ('01-01-1980', 'MM-DD-YYYY'), TO_DATE('01-01-1990', 'MM-DD-YYYY') TO_DATE('01-01-1985',

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

3 Workspace Manager Valid Time Support

3.5.3 WM_GREATERTHANp2. otherwise, it returns 0. For example: WM_GREATERTHAN(TO_DATE('01-01-1980', 'MM-DD-YYYY'), TO_DATE … ('01-01-1990', 'MM-DD-YYYY') TO_DATE('01-01-1970', 'MM-DD-YYYY'), TO_DATE('01-01-1980', 'MM-DD-YYYY … ') = 1 WM_GREATERTHAN(TO_DATE('01-01-1980', 'MM-DD-YYYY'), TO_DATE('01-01-1990',

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

3 Workspace Manager Valid Time Support

3.5.6 WM_LESSTHAN… otherwise, it returns 0. For example: WM_LESSTHAN(TO_DATE('01-01-1980', 'MM-DD-YYYY'), TO_DATE('01-01 … -1990', 'MM-DD-YYYY') TO_DATE('01-01-1991', 'MM-DD-YYYY'), TO_DATE('01-01-1992', 'MM-DD-YYYY') = 1 … WM_LESSTHAN(TO_DATE('01-01-1980', 'MM-DD-YYYY'), TO_DATE('01-01-1990',

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

3 Workspace Manager Valid Time Support

3.5.1 WM_CONTAINS: WM_CONTAINS(TO_DATE('01-01-1980', 'MM-DD-YYYY'), TO_DATE('01-01-1990', 'MM-DD-YYYY') TO_DATE('01-01-1985 … ', 'MM-DD-YYYY'), TO_DATE('01-01-1988', 'MM-DD-YYYY') = 1 WM_CONTAINS(TO_DATE('01-01-1980', 'MM-DD … -YYYY'), TO_DATE('01-01-1990', 'MM-DD-YYYY') TO_DATE('01-01-1985',

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

3 Workspace Manager Valid Time Support

3.5.7 WM_MEETS: WM_MEETS(TO_DATE('01-01-1980', 'MM-DD-YYYY'), TO_DATE('01-01-1990', 'MM-DD-YYYY') TO_DATE('01-01-1990 … ', 'MM-DD-YYYY'), TO_DATE('01-01-1988', 'MM-DD-YYYY') = 1 WM_MEEETS(TO_DATE('01-01-1980', 'MM-DD-YYYY … '), TO_DATE('01-01-1990', 'MM-DD-YYYY') TO_DATE('01-01-1992',

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

3 Workspace Manager Valid Time Support

3.5.9 WM_RDIFFright. The following example returns the period between 01-Jan-1988 to 01-Jan-1990: WM_RDIFF(TO_DATE … ('01-01-1980', 'MM-DD-YYYY'), TO_DATE('01-01-1990', 'MM-DD-YYYY') TO_DATE('01-01-1985', 'MM-DD-YYYY … '), TO_DATE('01-01-1988', 'MM-DD-YYYY') The following example returns a value because p1 … .validTill is

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

OCI Date, Datetime, and Interval Functions

CommentsRefer to the TO_DATE conversion function described in the Oracle Database SQL Reference for a

Utilities, 10g Release 1 (10.1)

12 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',

DML Reference, 10g Release 1 (10.1)

23 STDDEV to TRACKPRG

23 STDDEV to TRACKPRGTO_CHAR TO_DATE TO_NCHAR TO_NUMBER TOD TODAY TOTAL TRACEFILEUNIT TRACKPRG

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

OCI Date, Datetime, and Interval Functions

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

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

3 Workspace Manager Valid Time Support

3.1 Valid Time Support: Introduction and Example, WMSYS.WM_PERIOD(TO_DATE('01-01-1990', 'MM-DD-YYYY'), TO_DATE('01-01-2005', 'MM-DD-YYYY')) ); INSERT … INTO employees VALUES( 'Baxter', 40000, WMSYS.WM_PERIOD(TO_DATE('01-01-2000', 'MM-DD-YYYY … '), DBMS_WM.UNTIL_CHANGED) ); INSERT INTO employees VALUES( 'Coleman', 50000, WMSYS.WM_PERIOD(TO_DATE('01-01 … -2003',

Advanced Replication Management API Reference, 10g Release 1 (10.1)

ALTER_REFRESH_TEMPLATE Procedure

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





Was this page helpful?

Integrated Cloud Applications & Platform Services