Hi,

want to log datetime values from different timezones into the DB via Java JDBC. All timestamps should be in GMT time, which my understanding the DB does anyhow (time in ms based on GMT).
I tried different approached with set/getTimestamp() but nothing worked. MySQL seems always use the client

The following approach works fine on MS SQL:

setTimestamp(pos, Timestamp, Calendar.getInstance(TimeZone.getTimeZone("GMT"));

getTimestamp(1, Calendar.getInstance(TimeZone.getTimeZone("GMT"));

ANy ideas how to make this work with MySQL?

Bernd

Hmmm ... very specific question there - I've not seen this particular issue.  

It might be a silly question, but have you checked that the clock and time zone are correctly set on the host that's running the MySQL server?    It's still quite common for folks to install a computer in a non-GMT part of the world and accept the default time zone ....

Second thought (to help you divide the problem and see if it's at the JDBC or MySQL end) - have you run a mysql client against your database and checked the time it's reporting?

---