Hi, Please help. I'm wondering how to use this snippet of sql statement into Hibernate.

<code>String sql = "SELECT TO_CHAR(DATE_FILED, 'DD-MON-YYYY') D_FILED";</code>

Does Hibernate has a to_date() function where one can specify the format as 'dd-mon-yyyy' as in the TO_CHAR() above? Thanks.

Taicode