title: CST/CDT date to MM/DD/YYYY hh:mm in oracle
body: <p>I have a csv file with data in timezones including CST and CDT.</p>
  
  <p>For eg:<br>
          07-Mar-2017 11:00:00 PM CST<br>
          03-Oct-2017 11:00:00 PM CDT  </p>
  
  <p>The date field in the csv is being stored as a varchar2(30).</p>
  
  <p>The target date field needs to be converted to the format shown below:  </p>
  
  <pre><code>     MM/DD/YYYY hh:mm
  </code></pre>
  
  <p>How can we go about doing this conversion in oracle considering we have two timezines in the source file? </p>
  
  <p>Please help.</p>
  
  <p>Thanks Much<br>
  Tina</p>