title: Changing SQL VARCHAR2 date to another date format
body: <p>I have a date (stored as a VARCHAR2) in a database with the format:</p>
  
  <pre><code>20090123_163842.865
  yyyyMMdd_hhmmss.ttt
  </code></pre>
  
  <p>and I want to make a SQL sentence to obtain:</p>
  
  <pre><code>23/01/2009 16:38:42,865
  dd/MM/yyyy hh:mm:ss,ttt
  </code></pre>
  
  <p>MY objective is to add it manually (I know that data can be exported from database, and imported into Excel, but I want to do it manually) to Excel as a recognizable Date.</p>
  
  <p>How should my SQL sentence be?</p>
  
  <p>I have tried to to it by:</p>
  
  <pre><code>select TO_TIMESTAMP(my_time_utc, 'YYYYMMDD_HH24MISS.FF3') from myTable
  </code></pre>
  
  <p>but I am only able to obtain:</p>
  
  <pre><code>2009-01-23 16:38:42.865
  </code></pre>
  
  <p>Thanks</p>