title: How to trim milliseconds of a timestamp field in oracle
body: <p>I have a table <code>EMPLOYEE</code> and it has two <code>TIMESTAMP</code> fields <code>"CRTE_DTM"</code> and <code>"END_DTM"</code>.</p>
  
  <p>I would like to create a view on top <code>EMPLOYEE</code> table where I can put some function on these two fields to return <code>TIMESTAMP</code> with only 3 precision of milliseconds.</p>
  
  <p>Example:</p>
  
  <p>If I have below row in <code>EMPLOYEE</code> table</p>
  
  <pre><code>CRTE_DTM
  ----------------
  10-SEP-02 02.10.10.123000000 PM
  </code></pre>
  
  <p>I would like to trim the timestamp to have only 3 precision in milliseconds, see below,</p>
  
  <pre><code>CRTE_DTM
  ----------------
  10-SEP-02 02.10.10.123 PM
  </code></pre>
  
  <p>Note: I'm using this view to load data into a table where <code>"CRTE_DTM"</code> and <code>"END_DTM"</code> fields are TIMESTAMP's</p>