title: Convert datetime to ddmmyyyy in SQL server
body: <p>I need to convert datetime to ddmmyyyy as string/varchar in sql server. Let me repeat, not dd/mm/yyyy. I have searched and found only related to dd/mm/yyyy</p>
  
  <pre><code>Datetime           VARCHAR
  '02-07-2014'       '02072014'
  </code></pre>