I'm using Hibernate 2.1.1 and Postgres 7.4.1.
I want to use the to_char function inside a query to retrieve the day of a date.
Is it possible?
I've tried using "session.createSQLQuery()" but keeps giving me:

net.sf.hibernate.QueryException: undefined alias: to_char ...


Does Hibernate support this kind of function in a query?

You could read the date as a java.util.Date (or timestamp etc) and get the day from the Java Class.

I don't know Postgres syntax but in HQL the to_date() function is not valid in the select clause as its an unknown function in the dialect (see Oracle as an example).

Thanks for the reply David.
I know the workarround. Just want to know if Hibernate supports functions like to_char in queries.

Assuming to_char() is valid for postgress it will accept it in the where clause. In the select clause it will need to be added to the Postgress Dialect (depending on the arguments). v2.2 have have improved parser that will help in this area.