title: How to get Time from DateTime format in SQL?
body: <p>I want to get only Time from DateTime column using SQL query 
  using SQL Server 2005 and 2008
  Default output:</p>
  
  <pre><code>AttDate                   
  ==
  2011-02-09 13:09:00    
  2011-02-09 14:10:00    
  </code></pre>
  
  <p>I'd like this output:</p>
  
  <pre><code>AttDate                Time 
  ==
  2011-02-09 13:09:00    13:09
  2011-02-09 14:10:00    14:10
  </code></pre>