title: Derby Timestamp Comparison
body: <p>Currently I work with an Apache Derby database and there I have a problem. 
  There is a column that has datatype TIMESTAMP. Now with Java I access to this column, but I want just find records with a certain date.</p>
  
  <p>For example, the entries in column colTime:</p>
  
  <ul>
  <li>2013-08-14 18:20:00.0</li>
  <li>2013-08-15 18:20:00.0</li>
  <li>2013-08-15 18:21:00.0</li>
  <li>2013-08-16 18:20:00.0</li>
  </ul>
  
  <p>And now I want to find all entries with date 2013-08-15.</p>
  
  <p>I don't know, should my SQL query look like this? I didn't think so..</p>
  
  <pre><code>st.executeQuery("SELECT * FROM table_1 WHERE DATE(colTime)=DATE(TIMESTAMP("
      + new Timestamp(time.getTimeInMillis()) + ")");
  </code></pre>