1 Reply Latest reply on Aug 12, 2007 7:26 PM by Pete Muir

    Generic way to truncate date

    Steve Rose Newbie

      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