title: Implicit conversion from data type varbinary to date SQL server
body: <p>I have a procedure which takes a <code>date</code> value as parameter and then inserts the date value in a table:</p>
  
  <pre><code>CREATE PROCEDURE dbo.procInsert
      @employed_on    DATE
  AS
  BEGIN
      INSERT INTO dbo.TBL(EMPLOYED_ON)
      VALUES(@employed_on)
  END
  </code></pre>
  
  <p>however i am getting this error:</p>
  
  <blockquote>
    <p>Implicit conversion from data type varbinary to date is not allowed.
    Use the CONVERT function to run this query.</p>
  </blockquote>
  
  <p>I tried to use <code>convert</code> but its not working.</p>
  
  <p>UPDATE
  i found my mistake. i swapped the variables for insert. </p>