title: Date format in dd/MM/yyyy hh:mm:ss
body: <p>I need to convert datetime from <code>2012-07-29 10:53:33.010</code> to
  <code>29/07/2012 10:53:33</code>.</p>
  
  <p>I tried using</p>
  
  <pre><code>select CONVERT(varchar(20), GETDATE(), 131)
  </code></pre>
  
  <p>but its showing date according to Hijri calendar</p>
  
  <pre><code>11/09/1433 10:53:33:
  </code></pre>
  
  <p>Please help?</p>