title: How to specify a date value parameter in Toad for an Oracle Query using the query parameter window?
body: <p>In the following hard coded query I have two varchar2 params and two date params.</p>
  
  <pre><code>select * from myTable
  where title = 'abc'
  and start_date = TO_DATE('04/05/2016', 'mm/dd/yyyy')
  and end_date = TO_DATE('04/06/2016', 'mm/dd/yyyy')
  and description = 't';
  </code></pre>
  
  <p>This query returns two rows.</p>
  
  <p>When I run the same query using the Toad query parameter value entry window</p>
  
  <pre><code>select * from myTable
  where title = :ttitle 
  and start_date = :startdate
  and end_date = :enddate 
  and description = :descrip;
  </code></pre>
  
  <p>I enter  abc  for the ttitle param, 2016/04/05 for the startdate, 2016/04/06 for the enddate and  t  for the description.  Then I receive the following error for the date params</p>
  
  <p>ORA-01861: literal does not match format string</p>
  
  <p>I have tried other variations for the date '04/05/2016', I tried the entire TO_DATE('04/05/2016'....), ... and other formats, but keep getting errors.  Note:  if I comment out the date params and just use the varchar2 params, the query runs when I enter in   abc   and    t.  My problem is with the date params.  What is the correct way to enter the date values in the parameter window for Toad?</p>