<timestamp> - Changing default DB function

geminine · **Posted:** Thu Dec 23, 2010 8:02 am

Hi,

I'm using MS SQL 2005 and by default hibernate uses current_timestamp to get latest timestamp. I want to use GetUTCDate() function. Is it possible to configure or udpate it? I checked documentation but didn't come across anything.

Code:

sanne.grinovero · **Posted:** Thu Dec 23, 2010 8:06 am

hi,
extend org.hibernate.dialect.SQLServerDialect and override this method:

Code:

public String getCurrentTimestampSelectString() {
      return "select current_timestamp";
   }

Then you configure your custom Dialect http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html_single/#configuration-optional-dialects

geminine · **Posted:** Thu Dec 23, 2010 8:16 am

s.grinovero wrote:

Then you configure your custom Dialect http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html_single/#configuration-optional-dialects

To understant correctly, replace org.hibernate.dialect.SQLServerDialect with my own dialect, say com.sample.dialect.MySQLServerDialect. I have never done this before but won't there be any impact on application?

sanne.grinovero · **Posted:** Thu Dec 23, 2010 8:21 am

Try it out, hopefully you have tests to verify this.
as long as your implementation extends the default one, and only overrides what you need, the other functions won't be affected.
Of course if you change more things, you will affect more areas.

geminine · **Posted:** Thu Dec 23, 2010 8:36 am

I overrode only getCurrentTimestampSelectString() and it worked as expected. Thanks for that.

Hope there won't be any impact on app.