title: What format string can I use to parse an Oracle TIMESTAMP?
body: <p>I have the following value stored in an Oracle <code>TIMESTAMP</code> column <code>05-JAN-18 12.00.00.000000000 AM</code>.  I am trying to parse the values and convert them to something that is SQL Server <code>DATETIME</code> friendly. This is what I am trying to do:</p>
  
  <pre><code>DateTime result;
  DateTime.TryParseExact(
      "05-JAN-18 12.00.00.000000000 AM",
      "dd-MMM-yy hh.mm.ss.fffffff tt", 
      new CultureInfo("en-US"), DateTimeStyles.None,
      out result))
  </code></pre>
  
  <p>except this is not working because the format string does not have the precision to parse all of the milliseconds. How can I get around this? Is there a different format string I can use, or a better way to convert Oracle <code>TIMESTAMP</code> to <code>DateTime</code>?</p>