Hi ,
I have a couple of questions regarding the NLS_DATE_FORMAT in Ora10g....
- Why the following is null.....
SQL> SHOW PARAMETER NLS_DATE_FORMAT;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_date_format string
whereas the following...
SQL> SELECT * FROM DATABASE_PROPERTIES;
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
------------------------------ -------------------------------------------------------------------------------- --------------------------------------------------------------------------------
DICT.BASE 2 dictionary base tables version #
DEFAULT_TEMP_TABLESPACE TEMP Name of default temporary tablespace
DEFAULT_PERMANENT_TABLESPACE USERS Name of default permanent tablespace
DEFAULT_TBS_TYPE SMALLFILE Default tablespace type
NLS_LANGUAGE AMERICAN Language
NLS_TERRITORY AMERICA Territory
NLS_CURRENCY $ Local currency
NLS_ISO_CURRENCY AMERICA ISO currency
NLS_NUMERIC_CHARACTERS ., Numeric characters
NLS_CHARACTERSET UTF8 Character set
NLS_CALENDAR GREGORIAN Calendar system
NLS_DATE_FORMAT DD-MON-RR
is not...????
2)when i issue the command:
SQL> SELECT SYSDATE FROM DUAL;
SYSDATE
--------
20/10/07
whereas as above shown(dyn.view database_properties) the NLS_DATE_FORMAT is DD-MM-RR ...(it is not DD/MM/RR as the format of sysdate function returns)......
Many thenks,
Sim