i have a hql query

in the query i want to use the sql query special word is "CONVERT"

such as:


select convert(varchar(10),loginTime,20)

from admin group by convert(varchar(10,loginTime,20)

but when i ren the query use hibernate occure a error is

the "convert alias error"


how can i do

or the hibernate does not support "CONVERT"

or how to convert the sql query to hql


who can help me thanks everybody

You may also express queries in the native SQL dialect of your database.

Native SQLs are your queries that you write in your database.

Native SQL queries may be defined in the mapping document and called in exactly the same way as a named HQL query.

example:

<sql-query name="mySqlQuery">
<return alias="person" class="eg.Person"/>
SELECT person.NAME AS {person.name},
person.AGE AS {person.age},
person.SEX AS {person.sex}
FROM PERSON person WHERE person.NAME LIKE 'Hiber%'
</sql-query>

List people = sess.getNamedQuery("mySqlQuery")
.setMaxResults(50)
.list();

ok,i see you method but how can i use the method instance my

sql query ????can you tell me and thank you

my query is dynamic

so i haven't a good idea come true "convert" function from sql server


but hibernate can support "count" funciont

why not support "convert" or i am not know what the method

who can tell me????

hello Everybody

why not a person reply my question?????????????//



who can give me reply???555