SQL> select TO_char(new_time(to_date('2004-OCT-26 15:00:00','YYYY-MON-DD HH24:MI
:SS'),'PST','EST'),'YYYY-MON-DD HH24:MI:SS') FROM dual;TO_CHAR(NEW_TIME(TO_
--------------------
2004-OCT-26 18:00:00--这里转换是成功的SQL> select tzabbrev from v$timezone_names where tzname like '%Chongqing%';TZABBREV
----------------------------------------------------------------
LMT
LONT
CST
CDTSQL> select TO_char(new_time(to_date('2004-OCT-26 15:00:00','YYYY-MON-DD HH24:MI
:SS'),'LMT','PST'),'YYYY-MON-DD HH24:MI:SS') FROM dual;
select TO_char(new_time(to_date('2004-OCT-26 15:00:00','YYYY-MON-DD HH24:MI:SS')
,'LMT','PST'),'YYYY-MON-DD HH24:MI:SS') FROM dual *
ERROR at line 1:
ORA-01857: not a valid time zone--转换失败
SQL>
为什么明明可以从v$timezone_names 中查询到LMT时区 可是在转换的时候却提示ORA-01857: not a valid time zone
:SS'),'PST','EST'),'YYYY-MON-DD HH24:MI:SS') FROM dual;TO_CHAR(NEW_TIME(TO_
--------------------
2004-OCT-26 18:00:00--这里转换是成功的SQL> select tzabbrev from v$timezone_names where tzname like '%Chongqing%';TZABBREV
----------------------------------------------------------------
LMT
LONT
CST
CDTSQL> select TO_char(new_time(to_date('2004-OCT-26 15:00:00','YYYY-MON-DD HH24:MI
:SS'),'LMT','PST'),'YYYY-MON-DD HH24:MI:SS') FROM dual;
select TO_char(new_time(to_date('2004-OCT-26 15:00:00','YYYY-MON-DD HH24:MI:SS')
,'LMT','PST'),'YYYY-MON-DD HH24:MI:SS') FROM dual *
ERROR at line 1:
ORA-01857: not a valid time zone--转换失败
SQL>
为什么明明可以从v$timezone_names 中查询到LMT时区 可是在转换的时候却提示ORA-01857: not a valid time zone
Local Mean Time?那肯定不行
换成CST,中国标准时间
SQL> select tzabbrev from v$timezone_names where tzname like '%Shanghai%';TZABBREV
----------------------------------------------------------------
LMT
CST
CDT
我去网上查查看
SQL> select TO_char(new_time(to_date('2004-OCT-26 15:00:00','YYYY-MON-DD HH24:MI 2 :SS'),'CST','PST'),'YYYY-MON-DD HH24:MI:SS') FROM dual
3 ;TO_CHAR(NEW_TIME(TO_
--------------------
2004-OCT-26 13:00:00
--CST是可以的