In HQL, function ROUND always returns an Integer, it truncate the decimal part of Double number. ------------------------------------------------------------------------------------------------ Key: HHH-4769 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4769 Project: Hibernate Core Issue Type: Bug Components: core, entity-manager, query-hql Affects Versions: 3.3.2 Environment: hibernate 3.3.2, mysql-connector-java-5.1.7, database MYSQL 5. Reporter: Andrea Tunesi Priority: Blocker Running the query "select round(stTmpRiepCap.imponibile,1), round(stTmpRiepCap.ritImponibile,1) from StTmpRiepCap stTmpRiepCap", it always returns an Integer and it always truncate the decimal part of Double number ("stTmpRiepCap.imponibile" and "stTmpRiepCap.ritImponibile" are "java.lang.Double"). Example REAL VALUE - Imponibile: 1528.57 -- Ritenuta imponibile 266.13 VALUE RETURNED USING ROUND - Imponibile: 1528 -- Ritenuta imponibile 266 -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira