Help with Datestyle query

NBee · **Joined:** Fri Jul 28, 2006 5:59 am **Posts:** 7

Hi all.

In my existing app which I just converted to Hibernate, I had a query which said:

Code:

SET datestyle to EURO

I need to get this to execute via Hibernate, but I get the following error:

QuerySyntaxException: unexpected token: SET near line 1, column 1

Any tips how I can execute this please?

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

Use JDBC. session.connection().createStatement("SET datestyle to EURO") or similar.