Hello, I am trying to figure out a way to truncate a date so that it works for both SQL Server and Oracle. Presently I just use trunc in my queries for Oracle , but this does not work in SQL Server. I thought that the dialect would convert the trunc function to its SQL Server equivalent but thats not the case. Is there anything in hibernate that can do this? Thanks View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4073406#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...