title: Date range in select
body: <p>I have this table</p>
  
  <pre><code>CREATE TABLE Table1 (
      MY_ID  INTEGER NOT NULL,
      SCAN_TIME    TIMESTAMP NOT NULL,
      WORKCELL_ID  SMALLINT
  );
  </code></pre>
  
  <p>My problem when I use select SQL to get records between two dates I get empty result if the user select the same date for the two dates</p>
  
  <p>For ex:</p>
  
  <pre><code>Select * from Table1 
  where SCAN_TIME between '20.9.2014' and '20.9.2014'
  </code></pre>
  
  <p>Although there are records in that date '20.9.2014' but I get empty result and I get results only if I increase the second date by one day to be '21.9.2014' !! why is that and how I should fix ?</p>