title: Error converting date time to smalldatetime
body: <p>I  had created 3 views in SQL server, the first and the second view have a small date time columns and the second one has date time, so in order to do union between the views I convert date time into a small date time using the function convert in SQL server like so:</p>
  
  <pre><code>Convert (SMALLDATETIME, V_date)
  </code></pre>
  
  <p>I had this error: </p>
  
  <pre><code>error in converting a varchar to smalldatetime 
  </code></pre>
  
  <p>Note I used cast and always it is the same error. I don't understand why it gets me <code>varchar</code> in the error message because the column value (<code>V_date</code>) in the origin is datetime.</p>