title: error: Conversion failed when converting date and/or time from character string when i select date?
body: <p>i have this gridview, and i use sqldatasource</p>
  
  <p>this is my select command,</p>
  
  <pre><code>&lt;asp:SqlDataSource ID="SqlDataSource1" runat="server" 
      ConnectionString="&lt;%$ ConnectionStrings:TAXIConnectionString %&gt;" 
      SelectCommand="SELECT [TripId] FROM [BookingMaster] 
                      WHERE(([PickupLocation] = @PickupLocation or @PickupLocation is null) 
                      AND ([DestinationLocation] = @DestinationLocation 
                      or @DestinationLocation is null ) 
                      AND ([Status] = @Status or @Status is null) 
                      AND (cast([PickupDateTime] as date) = @PickupDateTime 
                      or @PickupDateTime is null))" 
       CancelSelectOnNullParameter="False"&gt;
           &lt;SelectParameters&gt;
               &lt;asp:ControlParameter ControlID="ddPickup" Name="PickupLocation" 
                    PropertyName="SelectedValue" Type="String" 
                    ConvertEmptyStringToNull="true" /&gt;
              &lt;asp:ControlParameter ControlID="ddDestination" Name="DestinationLocation" 
                   PropertyName="SelectedValue" Type="String" 
                   ConvertEmptyStringToNull="true" /&gt;
              &lt;asp:ControlParameter ControlID="ddStatus" Name="Status" 
                   PropertyName="SelectedValue" Type="String" 
                   ConvertEmptyStringToNull="true" /&gt;
              &lt;asp:ControlParameter ControlID="txtBookingDate" Name="PickupDateTime" 
                   PropertyName="Text" Type="String" ConvertEmptyStringToNull="true" /&gt;
          &lt;/SelectParameters&gt;
      &lt;/asp:SqlDataSource&gt;    
  </code></pre>
  
  <p>but the error came as i select date after 13 or else...</p>
  
  <pre><code>Server Error in '/' Application.
  
  Conversion failed when converting date and/or time from character string.
  </code></pre>
  
  <p>whats wrong with this?</p>