title: SQLite less than operator problem
body: <p>I am using SQLite for a project and &lt; symbol is not working in the query.</p>
  
  <p>There is a table named Holidays which has a field of datatype datetime.</p>
  
  <p>Suppose the table contains some dates of current year in the column HolidayDate.</p>
  
  <pre><code>SELECT HolidayDate
    FROM Holidays
   WHERE (HolidayDate &gt;= '1/1/2011')
     AND (HolidayDate &lt;= '1/1/2012')
  </code></pre>
  
  <p>The &lt; symbol in the above query is not working. > symbol in the above query is working well.</p>
  
  <p>Please help me.</p>