title: Error converting data type nvarchar to datetime
body: <p>I have the following procedure interface:</p>
  
  <pre><code>Create procedure [dbo].[InsertItemDetails]
      @TimeItemAdded datetime
  </code></pre>
  
  <p>When I call it this way:</p>
  
  <pre><code>EXEC [dbo].[InsertItemDetails]
       @TimeItemAdded = N'20/07/2012 00:00:00';
  </code></pre>
  
  <p>I get this error:</p>
  
  <blockquote>
    <p>Msg 8114, Level 16, State 5<br>
    Error converting data type nvarchar to datetime.</p>
  </blockquote>