title: SQL Server date format function
body: <pre><code>SELECT CONVERT(VARCHAR(10), GETDATE(), 105)  
  </code></pre>
  
  <p>This query return the date in the [DD-MM-YYYY]
   format as varchar. I need the same format in datetime datatype in sql server. Pls help me out</p>