Hi ! > -----Original Message----- > From: Richard Bolen [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 16, 2002 2:25 PM > To: MySQL Mailing List (E-mail) > Subject: MySQL subtracting an hour from DATETIME types I insert? > > > I have a java application accessing MySQL via the mm.mysql > type 4 jdbc driver. It appears that when I insert a record > with a DATETIME type in it, it's subtracting an hour from the time. > > Does anyone know why this might be happening? Is it a > timezone or daylight savings time issue? My server daemon > has 'eastern daylight time' as the timezone, which I believe > is the correct timezone. > > I have the same application running on top of an Oracle DB > and the times are stored correctly. >
It got fixed in 2.0.9, so you should try the latest version. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php