title: How to get the hour difference between 2 datetimestamp on derby db?
body: <p>I have a sql question on derby database:</p>
  
  <pre><code>Select a.name, a.starttime, a.endtime
  From a
  </code></pre>
  
  <p>How can I add to the above sql statement such that I can get the difference in hours between the start time and end time? (I only know that for mysql there is a DATEDIFF function, but I am not sure about what function should I use for derby db)</p>
  
  <p>Thanks.</p>