title: SQL convert string to date format 112
body: <p>I have an input date and I need to convert it to format 112 (yyyymmdd) for use later on in my SQL statement.</p>
  
  <pre><code>declare @day varchar(10)
  
  set @day = '6/21/2013'
  
  select @day
  </code></pre>
  
  <p>I've done this before...IDK if it's because I'm on SQL 2000 for this project that it's not working now.</p>