SQL> create table ff(a timestamp(8) with time zone);
Table created.
SQL> desc ff;
Name Null? Type
----------------------------------------- -------- ----------------------------
A TIMESTAMP(8) WITH TIME ZONE
SQL> insert into ff values(TO_TIMESTAMP_TZ('2006-12-14 19:45:09.9003 -12:00', 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM'));
1 row created.
SQL> select * from ff;
A
---------------------------------------------------------------------------
14-DEC-06 07.45.09.90030000 PM -12:00
SQL> insert into ff values(TO_TIMESTAMP_TZ('2006-12-14 19:45:09.9003 -12:00', 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM'));
1 row created.
SQL> insert into ff values(TO_TIMESTAMP_TZ('2006-12-14 19:45:09.9003 -13:00', 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM'))
*
ERROR at line 1:
ORA-01874: time zone hour must be between -12 and 13
错误解析:原因是-13,超过时区-12到13区间。
SQL> insert into ff values(TO_TIMESTAMP_TZ('2006-12-14 19:45:09.9003 13:00', 'YYYY-MM-DD HH24:MI:SS.FF TZH:TZM'))
1 row created.
--------------------------
注意缩写: "TZH" time zone hour, "TZM" time zone minute
Oracle TIMESTAMP WITH TIME ZONE类型TIMESTAMP WITH TIME ZONE类型Oracle定义的语法:TIMESTAMP [(fractional_seconds_precision)] WITH TIME ZONE该类型在TIMESTAMP类型的基础上增加了时区的信息. 注意时区时差(TZH)的范围是"-12 ~ 13", fractional_seconds_precision的使用与TIMESTAMP类型是一致的. 在数据库中保存占13字节.eg:SQL> cr