Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Index > ORACLE Server Parameters > nls_date_format

nls_date_format


Oracle 11.1.0:

Parameter Name:nls_date_format
Description:NLS Oracle date format
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:FALSE

Oracle 10.2.0:

Parameter Name:nls_date_format
Description:NLS Oracle date format
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:FALSE

Oracle 10.1.0:

Parameter Name:nls_date_format
Description:NLS Oracle date format
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:FALSE

Oracle 9.2.0:

Parameter Name:nls_date_format
Description:NLS Oracle date format
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:FALSE

Oracle 8.1.7:

Parameter Name:nls_date_format
Description:NLS Oracle date format
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:FALSE

Oracle 8.0.6:

Parameter Name:nls_date_format
Description:NLS Oracle date format
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:TRUE Can ALTER SYSTEM:FALSE

Oracle 7.3.4:

Parameter Name:nls_date_format
Description:NLS Oracle date format
Type:CHAR Obsoleted:FALSE
Can ALTER SESSION:FALSE Can ALTER SYSTEM:FALSE

Related Error Messages:

ORA-14120: incompletely specified partition bound for a DATE column
    Cause: An attempt was made to use a date expression whose format does not fully (i.e. day, month, and year (including century)) specify a date as a partition bound for a DATE column. The format may have been specified explicitly (using TO_DATE() function) or implicitly (NLS_DATE_FORMAT).

    Action: Ensure that date format used in a partition bound for a DATE column supports complete specification of a date (i.e. day, month, and year (including century)). If NLS_DATE_FORMAT does not support complete (i.e. including the century) specification of the year, use TO_DATE() (e.g. TO_DATE('01-01-1999', 'MM-DD-YYYY') to fully express the desired date.

ORA-21526: initialization failed

    Cause: The initialization sequence failed. This can happen, for example, if an environment variable such as NLS_DATE_FORMAT is set to an invalid value.

    Action: Check that all NLS environment variables are well-formed.


This parameter is documented in the Oracle Server Reference Guide. Search for more info about [ nls_date_format ] on the Oracle FAQ.

HOME | ASK QUESTION | ADD FAQ | SEARCH | E-MAIL US