Good Afternoon,

Is there a CONVERT type equivalent in standard HQL for formatting the decimal precision of Numbers (doing division in a HQL statement so what to restrict the precision in the Result set - not in the mapping)?

For instance in SQL (Server) I may do something like this to limit precision to 3 decimal places:

CONVERT(Decimal(15,3),A_TableOfSomeKind.EntryAmount)

Cheers

Mat

I have a similar problem to translate CONVERT to hql. The parser tells me "No data type for node: org.hibernate.hql.ast.tree.MethodNode" with a select with a CONVERT(varchar, column, style) as attribute.

With Hibernate 3.2.2 and SQL Server 2005.

Thanks for any advice or ideas.