title: H2 Database - DATEDIFF not working properly
body: <p>I'm trying to retrive a list of people based on their age, using H2 DB.</p>
  
  <p>I'm using this query:</p>
  
  <pre><code>DATEDIFF('YEAR', BIRTHDATE, CURRENT_DATE)
  </code></pre>
  
  <p>However, if the BIRTHDATE is Oct-24-1981, H2 returns 36, and it should be 35. This person will turn 36 in October-24, so it seems H2 is only substracting actual year with the year of birth (2017-1981=36), and that's not accurate.</p>
  
  <p>I know I could solve this using java, but it would take a lot of extra processing. Users need to search for all the people of a given age from the database. I'm using H2 version 1.4.195</p>
  
  <p>Any help will be appreciated!!</p>