日期格式模型元素在文档中列出：

SELECT to_timestamp_tz ('2014-09-12T11:53:06+00:00', 'YYYY-MM-DD"T"HH24:MI:SSTZH:TZM')
FROM DUAL

TO_TIMESTAMP_TZ('2014-09-12T11:53:06+00:00','YYYY-MM-DD"T"HH24:MI:SSTZH:TZM
---------------------------------------------------------------------------
12-SEP-14 11.53.06.000000000 +00:00

固定的 T 可以作为字符文字包含：

The fixed T can be included as a character literal:

您可以在日期格式模型中包含这些字符：

You can include these characters in a date format model:

• 标点符号，如连字符，逗号，句点和冒号


• 用双引号括起的字符文字

TZH 是tome区域小时， TZM 是时区分钟。其余的是更常见的模型元素。

TZH is tome zone hour, and TZM is time zone minutes. The rest are more common model elements.