title: Oracle giving ORA-01821 on a format that appears to be valid
body: <p>Calling </p>
  
  <pre><code>SELECT TO_DATE('Mon Sep 22 18:02:41 CDT 2014', 'DY MON DD HH24:MI:SS TZD YYYY') FROM Dual;
  </code></pre>
  
  <p>I get </p>
  
  <pre><code>ORA-01821: date format not recognized
  01821. 00000 -  "date format not recognized"
  </code></pre>
  
  <p>I put together the format string from <a href="https://www.techonthenet.com/oracle/functions/to_date.php" rel="nofollow noreferrer">these Oracle instructions</a>.  I tried both "TZR" and "TZD", neither works.</p>
  
  <pre><code>DY  Abbreviated name of day.
  MON Abbreviated name of month.
  DD  Day of month (1-31).
  HH24    Hour of day (0-23).
  MI  Minute (0-59).
  SS  Second (0-59).
  TZD Daylight savings information. For example, 'PST'
  TZR Time zone region.
  YYYY    4-digit year
  </code></pre>
  
  <p>Why is this not working?</p>