title: MySql - Using concat with date columns
body: <p>When i try to concat to date columns in my table like so:</p>
  
  <pre><code>CONCAT(`date_from`,' - ',`date_to`) AS `period`
  </code></pre>
  
  <p>I get a wierd result, something like this:</p>
  
  <pre><code>323031322d30312d303120323031322d30312d3031
  </code></pre>
  
  <p>But if i change the type of the column from DATE to VARCHAR the result is correct.</p>
  
  <p>Why can't I concat date columns?</p>