title: SQL server convert a column from string to date
body: <p>I have a column <code>stocked</code> as a <code>nvarchar(50)</code> containing dates of this format <code>('yyyy/mm/dd')</code>, i'd like to convert it to date so i can do some dateadds to make further comparaisons. </p>
  
  <p>Nothing that i've seen so far has been working (was a lot about casts and converts) and always resulted in stuff like that : <br/></p>
  
  <blockquote>
    <p>"Msg 242, Level 16, State 3, Line 1
    The conversion of a varchar data type to a datetime data type resulted in an out-of-range value."</p>
  </blockquote>