title: Error converting data type nvarchar to datetime SQL SERVER 2005
body: <p>I am getting error when I try to get result of my stored procedure. which take two value from the c# desktop applications. I write this procedure for getting today date result </p>
  
  <pre><code>-- Add the parameters for the stored procedure here
  @StartDate datetime,
  @LastDate datetime
  AS
  BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;
  
    -- Insert statements for procedure here
    SELECT * 
    from Visitor_Table 
    where Add_Date  BETWEEN @StartDate AND @LastDate
  END
  </code></pre>
  
  <p>In my data base date store in following format <code>14/08/2014 5:18:23 PM</code> but when I try to get today result and pass value <code>14/08/2014</code> it show error</p>
  
  <blockquote>
    <p>Error converting data type nvarchar to datetime</p>
  </blockquote>
  
  <p>I also try the value <code>14/08/2014 9:18:23</code> but problem is same. Please suggest me what is the way to get the result of today </p>