title: SQL Convert Date Format from varchar
body: <p>I have a <code>varchar</code> column in a table that contains data that looks like this:</p>
  
  <pre><code>2010-06-24-00.00.00.000000
  </code></pre>
  
  <p>I need to convert it to a <code>Date</code> that looks like this:</p>
  
  <pre><code>6/24/2010
  </code></pre>
  
  <p>Using T-SQL. How can I do this? I'm using SQL Server 2012.</p>
  
  <p>What date format is this? <code>2010-06-24-00.00.00.000000</code></p>