title: issues with showing date with time format in sql
body: <p>I am trying to show only date here and not the time but whatever i do still is showing the time like this format 4/4/2014 12:00:00 AM.  I would like to remove the time portion of the date and only show the date.  What am i doing wrong here?
  here is my sql</p>
  
  <pre><code> SELECT
   DATEADD(DD, 
    CONVERT(INT, (DATEDIFF(DD, '1/1/1900', t.DT)/7)) * 7, '1/1/1900') [WeekBeginDate],                                 
    SUM(HOURS) AS TOTAL_HOURS
     FROM [DA2].[PMO].[TASK_TIME_TRACKER] t
      WHERE UID = 'John07'
      AND DT &gt;= DATEADD(WEEK, -4, GetDate())
       GROUP BY CONVERT(INT, DATEDIFF(DD, '1/1/1900', t.DT)/7)
  </code></pre>