title: Oracle (SQL Developer): How to convert TIMESTAMP string includeing UTC Offset
body: <h1>Objective</h1>
  
  <p>Identify the correct TIMESTAMP format and the cause of the issue.</p>
  
  <h2>Problem</h2>
  
  <p>Tring to load a CSV which includes timestamp including UTC offset. </p>
  
  <pre><code>2014-01-01T00:38:51.000+11:00
  </code></pre>
  
  <p>The format string is below.</p>
  
  <pre><code>YYYY-MM-DD"T"HH24:MI:SS.FF3TZH:TZM
  </code></pre>
  
  <p>However, getting an error message.</p>
  
  <blockquote>
    <p>Invalid format YYYY-MM-DD"T"HH24:MI:SS.FF3TZH:TZM  is specified.</p>
  </blockquote>
  
  <h2>SQL Developer</h2>
  
  <p><strong>TIMESTAMP</strong></p>
  
  <p><a href="https://i.stack.imgur.com/mlzWa.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mlzWa.png" alt="enter image description here"></a></p>
  
  <p><strong>TIMESTAMP with TZ</strong>
  <a href="https://i.stack.imgur.com/JxdRK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JxdRK.png" alt="enter image description here"></a></p>
  
  <p>Please suggest how to fix this and the reason.</p>
  
  <h2>References</h2>
  
  <p><a href="https://dba.stackexchange.com/questions/107403/oracle-9-convert-date-from-mm-dd-yyyy-hhmmss-format-to-iso8601-formatted-date">Oracle 9: Convert date from mm/dd/yyyy hh:mm:ss format to iso8601 formatted datetime [closed]</a></p>