title: How to cast varchar to datetime in sql
body: <p>I need to cast a string to a datetime so i can compare it later.</p>
  
  <p>The varchar that i have is like this format:</p>
  
  <pre><code>     29/11/2013 12:00:00 a.m.  
  </code></pre>
  
  <p>And i need it to cast to:</p>
  
  <pre><code>     2013-11-29 00:00:00.000
  </code></pre>
  
  <p>Im using MSSQL Server 2012</p>
  
  <p>Thx for all</p>