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 NLS_DATE_FORMAT


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


Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Collections and Records

National Language Support NLS parameters such as NLS_SORT, NLS_COMP, and NLS_DATE_FORMAT affect associative…FIRST and LAST Methods for Associative Array For an associative array indexed by PLS_INTEGER, the first and last elements are those with the smallest and largest indexes, respectively. For an associative array indexed by string, the first and last elements are those with the lowest and highest key values, respectively. Key values are in sorted order (for more information, see \" NLS Parameter Values

Database Reference, 12c Release 1 (12.1)

NLS_DATE_FORMAT

1.161 NLS_DATE_FORMATProperty Description Parameter type String Syntax NLS_DATE_FORMAT = \" format \" Default value … date format mask but not exceeding a fixed length Basic No NLS_DATE_FORMAT specifies the default date … must be surrounded by double quotation marks. For example: NLS_DATE_FORMAT = \"MM/DD/YYYY\" Note: The … value of this initialization

OLAP DML Reference, 12c Release 1 (12.1)

OLAP DML Options

NLS_DATE_FORMATThe NLS_DATE_FORMAT option specifies the default format for datetime values. Within a session, you … SQL statement ALTER SESSION SET option = value.   Data Type TEXT Syntax NLS_DATE_FORMAT =  option

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Collections and Records

NLS Parameter Values Affect Associative Arrays Indexed by StringNational Language Support (NLS) parameters such as NLS_SORT, NLS_COMP, and NLS_DATE_FORMAT affect

Database Gateway for DRDA User's Guide, 12c Release 1 (12.1)

Developing Applications

NLS_DATE_FORMAT SupportThe following table lists the four patterns that can be used for the NLS_DATE_FORMAT in ALTER … SESSION SET NLS_DATE_FORMAT: DB2 Date Format Pattern Example EUR DD.MM.YYYY 30.10.1994 ISO YYYY-MM-DD … date values in the twenty-first century: ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD'; INSERT

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Collections and Records

A collection method is a PL/SQL subprogram—either a function that returns information about a collection…(SYSDATE) as an index. If the value of NLS_DATE_FORMAT changes, then the value of (TO_CHAR(SYSDATE

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Subprograms

Table 8-4 Finer and Coarser Caching Granularitysettings that might vary from session to session (such as NLS_DATE_FORMAT and TIME ZONE ), make the … NLS_DATE_FORMAT specifies. If sessions that invoke get_hire_date have different NLS_DATE_FORMAT settings … , specify a format mask, removing the dependency on NLS_DATE_FORMAT. For example: TO_CHAR(date_hired, 'mm/dd

Database PL/SQL Language Reference, 12c Release 1 (12.1)

PL/SQL Dynamic SQL

Guards Against SQL Injectiondatetime values uses format models specified in the parameters NLS_DATE_FORMAT, NLS_TIMESTAMP_FORMAT, or … the value of NLS_DATE_FORMAT is '\"Month:\" Month', then in June, TO_CHAR(SYSDATE) returns 'Month … concatenation to build WHERE clause and because SYSDATE depends on the value of NLS_DATE_FORMAT. */ query … ; / Demonstrate

Database 2 Day Developer's Guide, 12c Release 1 (12.1)

Working in a Global Environment

About the NLS_DATE_FORMAT Parametermodel. For example: NLS_DATE_FORMAT='MM/DD/YYYY' For information about datetime format models, see … step  1. Example 7-4 changes the value of NLS_DATE_FORMAT, overriding the default value set by … are from SQL*Plus; their format is slightly different in SQL Developer. Example 7-4 NLS_DATE_FORMAT … Overrides NLS_TERRITORY Note

TimesTen In-Memory Database PL/SQL Developer's Guide, 12c Release 1 (12.1)

Data Types in PL/SQL in TimesTen

Date and timestamp formats: NLS_DATE_FORMAT and NLS_TIMESTAMP_FORMATDa te and timestamp formats: NLS_DATE_FORMAT and NLS_TIMESTAMP_FORMAT TimesTen does not support … user-specified NLS_DATE_FORMAT and NLS_TIMESTAMP_FORMAT settings. NLS_DATE_FORMAT is always ' yyyy-mm

Database SQL Language Reference, 12c Release 1 (12.1)

CURRENT_DATE

CURRENT_DATESESSION SET TIME_ZONE = '-5:0'; ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS'; SELECT

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Starting and Interacting with the RMAN Client

Setting Globalization Support Environment Variables for RMANBefore invoking RMAN, it may be useful to set the NLS_DATE_FORMAT and NLS_LANG environment … : NLS_LANG=american NLS_DATE_FORMAT='Mon DD YYYY HH24:MI:SS' If you are going to use RMAN to connect to an … : NLS_LANG=american_america.we8dec For the environment variable NLS_DATE_FORMAT to be applied and override … NLS_DATE_FORMAT

Database SQL Language Reference, 12c Release 1 (12.1)

NEW_TIME

NEW_TIMEfunction, you must set the NLS_DATE_FORMAT parameter to display 24-hour time. The return type is always … SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS'; SELECT NEW_TIME(TO_DATE('11-10-09 01:23:45

Database Reference, 12c Release 1 (12.1)

Using Quotation Marks

1.3.2.1.4 Using Quotation Marksin the nested string. For example: NLS_DATE_FORMAT = '''Today is'' MM/DD/YYYY' The second method is … to alternate single and double quotation marks. For example: NLS_DATE_FORMAT = '\"Today is\" MM/DD/YYYY'

Database Concepts, 12c Release 1 (12.1)

SQL

Session Control StatementsDD-HH24:MI:SS': ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY MM DD HH24:MI:SS'; Session control

Database SQL Language Reference, 12c Release 1 (12.1)

Format Models

Datetime Format Modelsthe NLS session parameters NLS_DATE_FORMAT, NLS_TIMESTAMP_FORMAT, and NLS_TIMESTAMP_TZ_FORMAT, or

Database SQL Language Reference, 12c Release 1 (12.1)

SYSDATE

SYSDATEreturned value is DATE, and the format returned depends on the value of the NLS_DATE_FORMAT initialization

Database SQL Language Reference, 12c Release 1 (12.1)

Data Type Comparison Rules

Security Considerations for Data Conversionsession parameters. Depending on the source data type, the parameter name is NLS_DATE_FORMAT … specified in the session parameter NLS_DATE_FORMAT. The result is concatenated into SQL text. A datetime

Database SQL Language Reference, 12c Release 1 (12.1)

TO_DATE

TO_DATEbe set explicitly by the NLS_DATE_FORMAT parameter. If fmt is J, for Julian, then char must be an … valid only if char uses the same format as is determined by the NLS_TERRITORY or NLS_DATE_FORMAT

Database SQL Language Reference, 12c Release 1 (12.1)

Data Type Comparison Rules

Implicit and Explicit Data Conversionreturn an unexpected year depending on the value of the NLS_DATE_FORMAT parameter. Algorithms for