title: Round to 2 decimal places in hibernate query language
body: <p>Hi can someone help me how to round to 2 decimal places in hql?<br>
  I can't find anything online. Below is my query:</p>
  
  <pre><code>Select p.amount as amt,p.desc from pay p, register r where r.type=?1 and r.code=?2;
  </code></pre>
  
  <p>I would be glad if someone can help on this.</p>
  
  <p>Technology used: hibernate, spring, java, primefaces 4.0, oracle database</p>