title: Concatenate String + date in SQL Server
body: <p>I have the following data:</p>
  
  <pre><code>KEY        ID         DATE
  123456789  09BA2038   01-01-2017
  </code></pre>
  
  <p>And I would like to concatenate it, but keep the original format of the date. When I try:</p>
  
  <pre><code>CONCAT(Key, '-', ID, '-', DATE) 
  </code></pre>
  
  <p>it gives me an output of </p>
  
  <pre><code>123456789-09BA2038-Jan 01 2017 11:00AM
  </code></pre>
  
  <p>But I would like the output to be</p>
  
  <pre><code>123456789-09BA2038-01-01-2017
  </code></pre>