如下:我想把格式改成yyyy-mm-dd;
alter system set nls_date_format = 'yyyy-mm-dd hh24:mi:ss' scope = spfile;重启数据库了,然后还是没修改过来吗?如下什么意思?tiger>show parameter nls_date_formatNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_date_format string yyyy-mm-dd hh24:mi:ss
tiger>select * from nls_session_parameters where parameter='NLS_DATE_FORMAT';PARAMETER VALUE
------------------------------------------------------------ --------------------
NLS_DATE_FORMAT DD-MON-RRtiger>select sysdate from dual;SYSDATE
--------------
09-1月 -13tiger>spool off
alter system set nls_date_format = 'yyyy-mm-dd hh24:mi:ss' scope = spfile;重启数据库了,然后还是没修改过来吗?如下什么意思?tiger>show parameter nls_date_formatNAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_date_format string yyyy-mm-dd hh24:mi:ss
tiger>select * from nls_session_parameters where parameter='NLS_DATE_FORMAT';PARAMETER VALUE
------------------------------------------------------------ --------------------
NLS_DATE_FORMAT DD-MON-RRtiger>select sysdate from dual;SYSDATE
--------------
09-1月 -13tiger>spool off
The value of this parameter can be any valid date format mask, and the value must be surrounded by double quotation s. For example:
NLS_DATE_FORMAT = "MM/DD/YYYY"alter system set nls_date_format = "yyyy-mm-dd hh24:mi:ss" scope = spfile;
修改注册表或是环境变量。增加nls_date_format='yyyy/mm/dd'。就可以了