title: format date to 105 in SQL Server after casting
body: <p>I have a problem: I have a datetime and I need the date to specific format</p>
  
  <p>So I just casted datetime to time</p>
  
  <pre><code>SELECT CAST (GETDATE() AS DATE) -- result (2011-06-08)
  </code></pre>
  
  <p>and for formatting I use convert</p>
  
  <pre><code>SELECT CONVERT(DATE, CAST (GETDATE() AS DATE), 105) --result (2011-06-08)
  
  105 format (dd-mm-yy)
  </code></pre>
  
  <p>but, the result of both is same,</p>
  
  <p><code>CONVERT</code> is not working for 105 formatting,</p>
  
  <p>Any ideas?</p>
  
  <p>thanks</p>