[jboss-user] [JBoss Seam] - Generic way to truncate date

[srose]

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#4073406

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4073406