日期:2014-05-17 浏览次数:20924 次
alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss'; select sysdate from dual;
------解决方案--------------------
select sysdate,to_char(sysdate,'yyyy-mm-dd hh:mi:ss') from dual
------解决方案--------------------
WORKGROUP\DINGJUN-PC>select sysdate from dual;
SYSDATE
--------------
27-4月 -10
WORKGROUP\DINGJUN-PC> select * from nls_session_parameters;
PARAMETER
VALUE
------------------------------------------
------------------------------------------------------ -----------------------
------------------------------------------
---------------------------------------------------------------------------
NLS_LANGUAGE
SIMPLIFIED CHINESE
NLS_TERRITORY
CHINA
NLS_CURRENCY
¥
NLS_ISO_CURRENCY
CHINA
NLS_NUMERIC_CHARACTERS
.,
NLS_CALENDAR
GREGORIAN
NLS_DATE_FORMAT
DD-MON-RR
NLS_DATE_LANGUAGE
SIMPLIFIED CHINESE
NLS_SORT
BINARY
NLS_TIME_FORMAT
HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AM
PARAMETER
VALUE