Trying to convert nvarchar stored as datetime to int
<p>I have a SQL date field that is stored as <code>nvarchar(max)</code>.</p>

<p>Example: <code>4/7/2016 12:50:03 AM</code></p>

<p>I need to convert this to <code>int</code>.</p>

<p>I have this: <code>cast(convert(char(8), DateField,112) as int)</code></p>

<p>but I'm getting an error message </p>

<blockquote>
  <p>Conversion failed when converting the varchar value '5/22/201' to data type int</p>
</blockquote>

<p>Obviously, <code>/</code> isn't an <code>int</code> character. Any suggestions??</p>