SQL> select to_char(sysdate,'fmDY Mon DD HH24:MM:SS yyyy') from dual;TO_CHAR(SYSDATE,'FMDYMONDDHH24:MM:SSYYYY') ---------------------------------------------------------------------- SAT Aug 10 10:8:50 2002
oracle时间变量是以儒略日格式储存的,只有时间。可以考虑在表中增加一个字段,储存时区的信息。
至于时区的显示,用‘E’或‘EE’都不行: oracle7.2.2上: SQL> select to_char(sysdate,'ee') from dual; ERROR: ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []oracle8.16上: SQL> select to_char(sysdate,'E') from dual; select to_char(sysdate,'E') from dual * ERROR 位于第 1 行: ORA-01822: era format code is not valid with this calendar 我想是calendar的问题
----------------------------------------------------------------------
SAT Aug 10 10:8:50 2002
oracle7.2.2上:
SQL> select to_char(sysdate,'ee') from dual;
ERROR:
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []oracle8.16上:
SQL> select to_char(sysdate,'E') from dual;
select to_char(sysdate,'E') from dual
*
ERROR 位于第 1 行:
ORA-01822: era format code is not valid with this calendar
我想是calendar的问题