title: Format date as yyyy-mm-dd hh:mm:ss.000
body: <p>I have this date: <code>7/19/2013</code></p>
  
  <p>I want to format it as the following:</p>
  
  <pre><code>2013-07-19 00:00:00.000
  </code></pre>
  
  <p>I tried this: </p>
  
  <pre><code>select convert(varchar(10),'7/19/2013',120)
  </code></pre>
  
  <p>But it is giving me the same result!</p>