2 messages in com.mysql.lists.javaRe: timezone problem
FromSent OnAttachments
w.winter04 Apr 2002 09:17 
Mark Matthews04 Apr 2002 12:58 
Subject:Re: timezone problem
From:Mark Matthews (mmat@thematthews.org)
Date:04/04/2002 12:58:49 PM
List:com.mysql.lists.java

Wait until tomorrow for MM.MySQL-2.0.12 :) There's a new release just about ready to go.

-Mark

----- Original Message ----- From: "w.winter" <w.wi@logitags.com> To: <ja@lists.mysql.com> Sent: Thursday, April 04, 2002 11:17 AM Subject: timezone problem

Hi,

I have a problem inserting Dates with the mm.mysql-2.0.11 driver. My timezone is GMT +1. If I insert for example new Date() with PreparedStatement.setTimestamp(), the date is saved as new Date() - 1h in mysql. This is not the case with the mm.mysql.jdbc-1.2c driver or when I perform an Insert in an Oracle database with an Oracle driver.What can I do to have the correct date inserted without changing the code too much (I run the same code against several databases with several drivers)

thanks for helping Wolfgang

___________________ Dr. Wolfgang Winter LogiTags Systems www.logitags.com

--------------------------------------------------------------------- Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail java@lists.mysql.com

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java@lists.mysql.com instead.