title: Operand type clash: datetime2 is incompatible with int (Between)
body: <p>I am trying to get records inbetween two dates, however when I run the SQL I get the following error:</p>
  
  <p>Operand type clash: datetime2 is incompatible with int</p>
  
  <pre><code>SELECT M.Id, M.MTimeInt, M.Date, CAST(D.Name AS TEXT) as Name 
  FROM C 
  JOIN N ON C.N_Id=N.Id 
  JOIN M ON M.N_Id=N.Id 
  JOIN MDish ON MDish.M_Id=M.Id 
  JOIN D ON D.Id=MDish.D_Id 
  WHERE C.Id=110 AND M.Date BETWEEN 2012-05-28 AND 2012-06-08
  </code></pre>
  
  <p>The SQL looks correct, but I can't seem to figure out why it is complaining, any idea?</p>
  
  <p>Thanks</p>