title: How can I convert a SQL Server date format to Oracle?
body: <p>I am working on migration of data from an old system to a new system. As part of migration, the data from the legacy system, (stored in files) is pumped into  MS SQL Server. Now my app runs on Oracle. I'm having a problem with the date/timestamp.   </p>
  
  <p>The timestamp format in MS SQL Server data is:</p>
  
  <blockquote>
    <p>2008.12.23 00:00:00</p>
  </blockquote>
  
  <p>Oracle expects:</p>
  
  <blockquote>
    <p>23/12/2008 00:00:00  </p>
  </blockquote>
  
  <p>or  </p>
  
  <blockquote>
    <p>23-DEC-2008 00:00:00</p>
  </blockquote>
  
  <p>What would be the best way to import the data? Oracle's <code>to_date()</code> function didn't work as I thought it would.</p>