Hi I am trying to implement following SQL query using Hibernate, HQL....but not sure how to handle to_date and to_char function of SQL

INSERT INTO PWDTABLE(DATEPWDCHANGED) VALUES(TO_DATE(TO_CHAR(SYSDATE,'MM/DD/YYYY HH:MI:SS PM'),'MM/DD/YYYY HH:MI:SS PM'));

Basically I am looking at some HQL implementaion of this

Thanks and Regards

Sudhir

The normal way to do that sort of thing is to use UserTypes, and do all the conversion in java. If you want to use your DBMS' specific functions, you could use the <sql-insert> element in the relevant class. See section 16.4 of the ref docs.