HQL statement equivalent for to_char in PostgreSQL

SgCoder · **Joined:** Thu Sep 16, 2004 1:10 pm **Posts:** 5

Hi,

Can someone tell me what is the HQL statement equivalent for the following
sql statement ?

select to_char(dob,'DD/MON/YYYY') from user

Regards

Hibernate version:2.1

iranm · **Joined:** Wed Sep 03, 2003 9:31 am **Posts:** 26

Hi. I need that too. I'm using Hibernate 3.0.5.

I saw something about it in this topic:
http://forum.hibernate.org/viewtopic.php?t=934198.

David was saying something about version 3.x address this problem, but doesn't seems to work.

gavin · **Posted:** Thu Aug 18, 2005 10:33 am

I have now added these lines:

Code:

      registerFunction( "to_char", new StandardSQLFunction("to_char", Hibernate.STRING) );
      registerFunction( "to_date", new StandardSQLFunction("to_date", Hibernate.DATE) );
      registerFunction( "to_timestamp", new StandardSQLFunction("to_timestamp", Hibernate.TIMESTAMP) );
      registerFunction( "to_number", new StandardSQLFunction("to_number", Hibernate.BIG_DECIMAL) );

To PostgreSQLDialect.

iranm · **Joined:** Wed Sep 03, 2003 9:31 am **Posts:** 26

Hi Gavin. Is this working for which version?

sven · **Posted:** Thu Aug 18, 2005 1:02 pm

It probably meens it's working in CVS and you'll see it in the next release.

Best regards
Sven