title: Sql remove milliseconds and Date Conversion
body: <p>Please could any one suggest me getting the right results?</p>
  
  <p>I have a Date field which results in "2016-07-08 10:09:22.910" format and wish to remove milliseconds and same time wish to convert this field in to "08/07/2016 10:09:22"</p>
  
  <p>I managed to remove the milliseconds by using <code>CONVERT(VARCHAR, [DateFileCreated], 20)</code> but unable to convert this in to the desired format.</p>
  
  <p>Please suggest</p>