title: The conversion of a nvarchar data type to a datetime
body: <p>I have a table like this,</p>
  
  <p>table name:transaction_tbl</p>
  
  <p><img src="https://i.stack.imgur.com/pWnjc.png" alt="enter image description here"></p>
  
  <p>I have a stored procedure like this:</p>
  
  <pre><code>ALTER PROCEDURE [dbo].[Test] @startdate NVARCHAR(100),
                               @enddate   NVARCHAR(100)
  AS
    BEGIN
        SELECT t.PlateNo
        FROM   Transaction_tbl t
        WHERE  dtime BETWEEN @startdate + ' 00.01.00.00' AND @enddate + ' 23:59.59.00'
    END 
  </code></pre>
  
  <p>while executing this I am getting this error</p>
  
  <blockquote>
    <p>The conversion of a nvarchar data type to a datetime data type
    resulted in an out-of-range value. </p>
  </blockquote>
  
  <p>I am trying to pass my start date with starting time and end date with end time of the day,,</p>