title: Convert SQL to NHibernate HQL
body: <p>I should convert to the fallowing SQL-Query to NHibernate HQL (NHibernate 3.2). But I don't know, how I have to translate the FLOOR, DATEDIFF and GETDATE.</p>
  
  <pre><code>SELECT Birthday FROM Person
  WHERE 1 = (FLOOR(DATEDIFF(dd,Birthday,GETDATE()+10) / 365.25))
        -
        (FLOOR(DATEDIFF(dd,Birthday,GETDATE()-5) / 365.25))
  </code></pre>