title: How to convert datetime to time format
body: <p>I have a query that returns datetime format in sql:</p>
  
  <pre><code>SELECT time_in  
  FROM job_punch_card  
  WHERE emp_key=47 and punch_day&lt;= DATEADD(week, DATEDIFF(day, 0, getdate())/7, 0)
  </code></pre>
  
  <p>This returns results like <code>2014-2-15 07:36:32.000</code>, however I only want the time portion, not the dates. I can get the current time from SQL Server like: </p>
  
  <pre><code>SELECT CONVERT(VARCHAR(8),GETDATE(),108) AS HourMinuteSecond
  </code></pre>
  
  <p>But I couldn't apply this to my own query. How can I retrieve only time from <code>time_in</code> table above?</p>