title: What is the Oracle date formatting mask for time zones?
body: <p>I need to insert a date format from an outside source which includes the three letter code for time zone, but the <strong>TZD</strong> formatting mask does not seem to work...</p>
  
  <pre><code>insert into blah
      values (to_date('Thu, 18 Feb 2010 08:37:00 EST','Dy, DD Mon YYYY HH24:MI:SS TZD'));
  
  ORA-01821: date format not recognized
  </code></pre>
  
  <p>If I remove the "TZD"...</p>
  
  <pre><code>insert into blah
      values (to_date('Thu, 18 Feb 2010 08:37:00','Dy, DD Mon YYYY HH24:MI:SS'));
  
  1 row created.
  </code></pre>
  
  <p>What is the proper mask for such an insert statement in Oracle?</p>
  
  <pre><code>desc blah
   Name                      Null?    Type
   ----------------------------------------- -------- ----------------------------
   D                          DATE
  </code></pre>
  
  <p>Edit: I changed the table column from DATE type to TIMESTAMP type and got the same error.</p>