title: Get Time from Getdate()
body: <p>I would like to take the <code>Getdate()</code> results of, </p>
  
  <p>for example </p>
  
  <pre><code>2011-10-05 11:26:55.000
  </code></pre>
  
  <p>into</p>
  
  <pre><code>11:26:55 AM
  </code></pre>
  
  <p>I have looked other places and found</p>
  
  <pre><code>Select RIGHT(CONVERT(VARCHAR, GETDATE(), 100),7)
  </code></pre>
  
  <p>which gives me</p>
  
  <pre><code>11:26AM
  </code></pre>
  
  <p>It's so close I can taste it!</p>