title: Convert varchar to datetime SQL Server 2008
body: <p>I have a column of Date and Time like this:</p>
  
  <pre><code>  20/Mar/2013:02:28:47
    20/Mar/2013:02:28:43
    20/Mar/2013:02:28:47
    20/Mar/2013:02:28:47
    20/Mar/2013:02:28:47
    20/Mar/2013:02:28:47
    20/Mar/2013:02:28:41
    20/Mar/2013:02:28:46
  </code></pre>
  
  <p>the datatype of this column is set to "varchar". I just need to convert the following format of column to:  </p>
  
  <pre><code>  20/03/2013:02:28:47
    20/03/2013:02:28:43
    20/03/2013:02:28:47
    20/03/2013:02:28:47
    20/03/2013:02:28:47
    20/03/2013:02:28:47
    20/03/2013:02:28:41
    20/03/2013:02:28:46
  </code></pre>
  
  <p>also can i change its datatype from varchar to SQL date and time datatype!
  I am trying with my query like:</p>
  
  <pre><code> SELECT convert(mydatetimecolumn,105) from mytable
  </code></pre>
  
  <p>but it gives me the result like:</p>
  
  <pre><code>   1900-04-16 00:00:00.000
     1900-04-16 00:00:00.000
     1900-04-16 00:00:00.000
     1900-04-16 00:00:00.000
     1900-04-16 00:00:00.000
  </code></pre>
  
  <p>How can I overcome this problem? can somebody help me please? Thanks in advance!</p>