oracle如何以不同的格式显示日期

How to display date in a different format in oracle

我有一张带有日期字段的表格。默认情况下，select max(date) from table; 以 'dd-mmm-yy' 格式返回日期。如何在不更改表格结构或字段格式的情况下选择"MM/DD/YYYY"格式的日期。

谢谢，

上乘

select to_char(max(date), 'MM/DD/YYYY') from table;select to_char(sysdate,'mm/dd/yyyy') as maxdate from dual;SELECT * 

 FROM v$nls_parameters WHERE UPPER(PARAMETER) = 'NLS_DATE_FORMAT';



ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDD';HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ORACLE\\KEY_OraClient11g_home9select to_char(sysdate, 'MM/DD/YYYY')

from dual;

尝试以下方法：

select to_char(max(date), 'MM/DD/YYYY') from table;select to_char(sysdate,'mm/dd/yyyy') as maxdate from dual;SELECT * 

 FROM v$nls_parameters WHERE UPPER(PARAMETER) = 'NLS_DATE_FORMAT';



ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDD';HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ORACLE\\KEY_OraClient11g_home9select to_char(sysdate, 'MM/DD/YYYY')

from dual;

关于oracle特定函数to_char()的一些信息：

• http://www.techonthenet.com/oracle/functions/to_char.php

Exists a table or view v$nls_parameters 在这里搜索参数\\'NLS_DATE_FORMAT\\'，这是完美的不改变格式。

select to_char(max(date), 'MM/DD/YYYY') from table;select to_char(sysdate,'mm/dd/yyyy') as maxdate from dual;SELECT * 

 FROM v$nls_parameters WHERE UPPER(PARAMETER) = 'NLS_DATE_FORMAT';



ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDD';HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ORACLE\\KEY_OraClient11g_home9select to_char(sysdate, 'MM/DD/YYYY')

from dual;

也有可能来自make for register of win。在树中

select to_char(max(date), 'MM/DD/YYYY') from table;select to_char(sysdate,'mm/dd/yyyy') as maxdate from dual;SELECT * 

 FROM v$nls_parameters WHERE UPPER(PARAMETER) = 'NLS_DATE_FORMAT';



ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDD';HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ORACLE\\KEY_OraClient11g_home9select to_char(sysdate, 'MM/DD/YYYY')

from dual;

这里键入 NLS_DATE_FORMAT，更改为您的格式日期。

查看 to_char 函数及其接受的日期/时间格式。

select to_char(max(date), 'MM/DD/YYYY') from table;select to_char(sysdate,'mm/dd/yyyy') as maxdate from dual;SELECT * 

 FROM v$nls_parameters WHERE UPPER(PARAMETER) = 'NLS_DATE_FORMAT';



ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDD';HKEY_LOCAL_MACHINE\\SOFTWARE\\Wow6432Node\\ORACLE\\KEY_OraClient11g_home9select to_char(sysdate, 'MM/DD/YYYY')

from dual;