title: How to covert to varchar column to date time where column is in mixed mode
body: <p>I have a column in sql server 2012. The column has date stored in varchar. The date data looks like this: dd/mm/yyyy</p>
  
  <p>However there is a catch. The data that is within the column is in refusing to convert. Details investigation reveals that some are convertible to date mode and others are not (may be due to date stored as text mode). I tried to upload the data in date format. But it is also refusing to do so.</p>
  
  <p>Sample Data:</p>
  
  <pre><code>Original    Validation Check
  10/03/1974  3/10/1974
  02/02/1990  2/2/1990
  16/05/1988  NULL
  </code></pre>
  
  <p>What should I do?</p>
  
  <p>PS: Found out that some data stored in that column is not in date format, so it was refusing to convert. Thanks to Mr. @Digvijay Verma, he correctly predicted it and with his help I identified the error. Only removing these error and replacing those with valid dates will do the trick.  </p>
  
  <p>Regards,
  Sadat</p>