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_TIMESTAMP


1 to 20 of 20 results. Previous page Prev  Next next page


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 147 of 177

TO_TIMESTAMPSyntax to_timestamp::= Text description of to_timestamp Purpose TO_TIMESTAMP converts char of CHAR … TO_TIMESTAMP ('1999-12-01 11:00:00', 'YYYY-MM-DD HH:MI:SS') FROM DUAL; TO_TIMESTAMP('1999-12-0111:00

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

TO_DSINTERVALTO_TIMESTAMP TO_TIMESTAMP_TZ

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

DBMS_FLASHBACK, 2 of 2

ParametersSupport settings. Using the TO_TIMESTAMP function: Example: execute dbms_flashback.enable_at_time … (TO_TIMESTAMP('12-02-2001 14:35:00', 'DD-MM-YYYY HH24:MI:SS')). Y ou provide the format you want to use … . This example shows the TO_TIMESTAMP function for February 12, 2001, 2:35 PM. If the time is omitted

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

Modeling and Design

Non-Supported SQL Functionality for LOBsMedia Text) SQL Conversion functions: TO_DATE, TO_NUMBER, TO_TIMESTAMP, CHARTOROWID, TO_MULTI_BYTE

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 64 of 177

LOCALTIMESTAMPreturn type of the function: INSERT INTO local_test VALUES (TO_TIMESTAMP(LOCALTIMESTAMP, 'DD-MON-RR … LOCALTIMESTAMP: INSERT INTO local_test VALUES (TO_TIMESTAMP(LOCALTIMESTAMP, 'DD-MON-RR HH.MI.SSXFF PM'));

Reference, 9i Release 2 (9.2.0.2)

Initialization Parameters, 126 of 222

NLS_TIMESTAMP_FORMATNLS_TIMESTAMP_FORMAT defines the default timestamp format to use with the TO_CHAR and TO_TIMESTAMP functions

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

Modeling and Design

Using SQL Functions and Operators for VARCHAR2s on CLOBsConversion TO_TIMESTAMP TO_TIMESTAMP(clobCol) No CNV Conversion TO_MULTI_BYTE TO_SINGLE_BYTE TO_MULTI_BYTE

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Setting Up a Globalization Support Environment

Time Formatsdefines the default timestamp format to use with TO_CHAR and TO_TIMESTAMP functions. The value must be … -15 Timestamp Format SQL> SELECT TO_TIMESTAMP('11-nov-2000 01:00:00.336', 'dd-mon-yyyy hh:mi:ss.ff … ') FROM dual; You should see output similar to the following: TO_TIMESTAMP('11-NOV-200001:00:00.336','DD … statement See Also:

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

Fundamentals of PL/SQL

Built-In FunctionsSESSIONTIMEZONE SYSDATE SYSTIMESTAMP TO_DSINTERVAL TO_TIMESTAMP TO_TIMESTAMP_LTZ TO_TIMESTAMP_TZ TO_YMINTERVAL

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 137 of 177

TO_DATEdatatypes. For information on other datetime conversions, please refer to TO_TIMESTAMP

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

Selecting a Datatype

Time FormatTO_TIMESTAMP TO_TIMESTAMP_TZ TO_YMINTERVAL See Also: Oracle9i SQL Reference for full details about each

SQL Reference, 9i Release 2 (9.2.0.2)

Basic Elements of Oracle SQL, 4 of 10

Date Format Modelsare TO_CHAR, TO_DATE, TO_TIMESTAMP, TO_TIMESTAMP_TZ, TO_YMINTERVAL, and TO_DSINTERVAL.) In the … , TO_DATE, TO_TIMESTAMP, TO_TIMESTAMP_TZ, TO_YMINTERVAL, and TO_DSINTERVAL. Oracle returns an error

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle9i SQL Reference -- Contents

Oracle9i SQL Reference -- ContentsTO_NCHAR (character) TO_NCHAR (datetime) TO_NCHAR (number) TO_NCLOB TO_NUMBER TO_SINGLE_BYTE TO_TIMESTAMP

New Features, 9i Release 2 (9.2.0.2)

Oracle9i Database Release 1 (9.0.1) New Features

SQL and PL/SQL ImprovementsSYS_XMLGEN SYSTIMESTAMP TO_CHAR (character) TO_CLOB TO_DSINTERVAL TO_TIMESTAMP TO_TIMESTAMP_TZ

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

How Oracle Processes SQL Statements

Tips for Using Flashback QuerySQL query. SELECT salary FROM employees AS OF TIMESTAMP to_timestamp('20-FEB-2002','DD-MON-YY … NUMBER; BEGIN dbms_flashback.enable_at_time(to_timestamp('20-FEB-2002','DD-MON-YY')); SELECT salary

SQL Reference, 9i Release 2 (9.2.0.2)

Basic Elements of Oracle SQL, 2 of 10

Data Conversion) TO_NCHAR (character) TO_NUMBER TO_DATE TO_TIMESTAMP TO_TIMESTAMP_TZ TO_YMINTERVAL TO_DSINTERVAL

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE CLUSTER to CREATE JAVA, 2 of 12

CREATE CLUSTER, SESSIONTIMEZONE, SYSDATE, SYSTIMESTAMP, TO_DSINTERVAL, TO_TIMESTAMP, TO_DATE, TO_TIMESTAMP_TZ

SQL Reference, 9i Release 2 (9.2.0.2)

Basic Elements of Oracle SQL, 2 of 10

Oracle Built-in Datatypes-31 09:26:50.124' See Also: TO_TIMESTAMP for information on converting character data to TIMESTAMP

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: ALTER SESSION to ALTER SYSTEM, 3 of 3

Initialization Parameters and ALTER SYSTEMNLS_TIMESTAMP_FORMAT defines the default timestamp format to use with the TO_CHAR and TO_TIMESTAMP functions

SQL Reference, 9i Release 2 (9.2.0.2)

What's New in SQL Reference?

Oracle9 i Release 1 (9.0.1) New Features in the SQL Reference(datetime) TO_NCHAR (number) TO_NCLOB TO_TIMESTAMP TO_TIMESTAMP_TZ TO_YMINTERVAL TREAT TZ_OFFSET