oracle查询 格式化日期,查看当前Oracle默认日期格式

SQL> select * from nls_session_parameters;

SQL> select * from nls_session_parameters;

PARAMETER VALUE

------------------------------ --------------------

NLS_LANGUAGE AMERICAN

NLS_TERRITORY AMERICA

NLS_CURRENCY $

NLS_ISO_CURRENCY AMERICA

NLS_NUMERIC_CHARACTERS .,

NLS_CALENDAR GREGORIAN

NLS_DATE_FORMAT DD-MON-RR

NLS_DATE_LANGUAGE AMERICAN

NLS_SORT BINARY

NLS_TIME_FORMAT HH.MI.SSXFF AM

NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXF

PARAMETER VALUE

------------------------------ --------------------

F AM

NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR

NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXF

F AM TZR

NLS_DUAL_CURRENCY $

NLS_COMP BINARY

NLS_LENGTH_SEMANTICS BYTE

NLS_NCHAR_CONV_EXCP FALSE

17 rows selected.

SQL> select * from nls_instance_parameters;

SQL> select * from nls_instance_parameters;

PARAMETER VALUE

------------------------------ --------------------

NLS_LANGUAGE AMERICAN

NLS_TERRITORY AMERICA

NLS_SORT

NLS_DATE_LANGUAGE

NLS_DATE_FORMAT

NLS_CURRENCY

NLS_NUMERIC_CHARACTERS

NLS_ISO_CURRENCY

NLS_CALENDAR

NLS_TIME_FORMAT

NLS_TIMESTAMP_FORMAT

PARAMETER VALUE

------------------------------ --------------------

NLS_TIME_TZ_FORMAT

NLS_TIMESTAMP_TZ_FORMAT

NLS_DUAL_CURRENCY

NLS_COMP

NLS_LENGTH_SEMANTICS BYTE

NLS_NCHAR_CONV_EXCP FALSE

17 rows selected.

SQL> select * from nls_database_parameters;

SQL> select * from nls_database_parameters;

PARAMETER VALUE

------------------------------ --------------------

NLS_LANGUAGE AMERICAN

NLS_TERRITORY AMERICA

NLS_CURRENCY $

NLS_ISO_CURRENCY AMERICA

NLS_NUMERIC_CHARACTERS .,

NLS_CHARACTERSET ZHS16GBK

NLS_CALENDAR GREGORIAN

NLS_DATE_FORMAT DD-MON-RR

NLS_DATE_LANGUAGE AMERICAN

NLS_SORT BINARY

NLS_TIME_FORMAT HH.MI.SSXFF AM

PARAMETER VALUE

------------------------------ --------------------

NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXF

F AM

NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR

NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXF

F AM TZR

NLS_DUAL_CURRENCY $

NLS_COMP BINARY

NLS_LENGTH_SEMANTICS BYTE

NLS_NCHAR_CONV_EXCP FALSE

PARAMETER VALUE

------------------------------ --------------------

NLS_NCHAR_CHARACTERSET AL16UTF16

NLS_RDBMS_VERSION 10.2.0.1.0

20 rows selected.