title: Convert Decimal or Varchar into Date
body: <p>I have 2 fields.</p>
  
  <p>Birth= Datatype Decimal(12,4) &amp; Date = Datatype Date</p>
  
  <pre><code>Birth         Date 
  19650101   2015-07-09  
  </code></pre>
  
  <p>how do i get a result that looks like this</p>
  
  <p>i want the result to be like this </p>
  
  <pre><code>Birth             Date          
  1965-01-01       2015-07-09       
  </code></pre>
  
  <p>where the Birth is a Date datatype and not a decimal (12,4)</p>