title: HSQL Get Date and Time from TIMESTAMP
body: <p>I have a HSQLDB table with some informations and where a timestamp is stored </p>
  
  <p>I want to select informations from specific time periods like every information of october between 0am and 5pm.</p>
  
  <p>I didn't found any function like mysql'ones  DATE(myfield) OR TIME(myfield) which would be perfect for what i want.</p>
  
  <pre><code>SELECT * FROM myTable 
  WHERE DATE(myField) BETWEEN '2012-10-01' AND '2012-10-30' 
  AND TIME(myField) BETWEEN '00:00:00' AND '17:00:00'
  </code></pre>
  
  <p>The only things i found are to use the functions YEAR(), DAYOFMONTH(), DAYOFYEAR(), HOUR() ANd MINUTE() but I was wondering if there aren't any other simpler solutions.</p>