title: SQL statement not working - "Operand type clash: date is incompatible with int'
body: <p>I have a table which i am trying to return the Time and Productno columns for a specific date. When i try the following SQL command it returns the error: "Operand type clash: date is incompatible with int'.
   I have research on forums and this is the way most people have been achieving a similar thing which is getting me puzzled.
  The data types for the following fields are as follows: Date: date. Time: time(7). Productno: int.</p>
  
  <pre><code>SELECT        Date, Time, Productno
  FROM            Products
  WHERE        (Date = 07 / 09 / 2008)
  </code></pre>
  
  <p>Please could i be advised where i am going wrong?</p>
  
  <p>Thanks.</p>