title: How can I concatenate two dates as strings in Sql
body: <p>I have a date field and i need to display the week of the date field in select statement,</p>
  
  <p>Eg : if the date is '2014-09-15 00:00:00', i need to display as '2014-09-14 to 2014-09-20 ' which is start day to end day of the week</p>
  
  <p>I have tried using </p>
  
  <pre><code>   Select dateadd(week, datediff(week, 0, getdate()), -1)+' to ' +DATEADD(wk, DATEDIFF(wk, 6, CURRENT_TIMESTAMP), 6 + 7) 
  </code></pre>
  
  <p>But it is giving me conversion failure,how can i write the above to display in sql</p>