title: how to trim Date portion from DateTime Field in sql
body: <p>i have a field that shows the date and time but i want to show only the time and would like to trim all the Date portion.  Here is what i have:</p>
  
  <pre><code>Field1
  Dec 30 1899 10:13AM
  </code></pre>
  
  <p>and i want to show only the time like this:</p>
  
  <pre><code>Field1
  10:13AM
  </code></pre>
  
  <p>I would like to use an update function to accomplish this.  How can i do this</p>
  
  <pre><code>UPDATE MyTable
  SET Field1=Time...
  </code></pre>
  
  <p>thanks</p>