[b]Hibernate version:3.1[/b]
[b]Name and version of the database you are using: MySQL 5.0.18[/b]
Hello all.
I'm executing a HQL query wich divides two integers and I want to obtain a double result, just like SQL does, but I see that HQL is doing an integer division (like java).
I try with 'cast (property as double)' but the cast to double doesn't work, casts to char, integer, string work fine, but not for double!
Anybody know if there is some way to obtain a double from a division between integers in HQL?, or cast to double?
Thanks to all.
|