title: Oracle Timestamp - date format not recognized
body: <p>I have a column in my table which is of type Timestamp.
  while converting this field to the format: <strong>2003-08-09T05:48:37+05:30</strong>, I am using the following query:</p>
  
  <pre><code>select 
  TO_CHAR(CONSUMER_DLY_TIME, 'YYYY-MM-DD"T"HH24:MI:SSTZH:TZM')
  from oms_cust_ord_head;
  </code></pre>
  
  <p>it gives me the error:  "date format not recognized"</p>
  
  <p>How to resolve this ?</p>