Hibernate HQL查询语法貌似不支持直接使用某些函数,其中就包括to_number 。例如:
1
|
select
max (to_number(o.ordernum)) from
className o
|
1
|
select
max ( cast (o.ordernum, int )) from
className o
|
1
|
select
* from
( select
max ( cast (projectatt0_.ORDERNUM as
number(10,0))) as
col_0_0_ from
DB_PROJECT_ATTACHMENT projectatt0_
|