MySQL time zone conversion issue

Asked Jul 30 '15 at 19:17

Active Dec 01 '15 at 09:25

Viewed 84 times

Is MySQL time zone conversion broken?

I want to save java timestamp to DATETIME db field.

Client time Jul 30, 09:00:00 (GMT-07:00)

In DB I got Jul 30, 02:00:00 (GMT)

Expected in GMT - Jul 30, 16:00:00 (GMT)

During debugging I found that conversion happens here

Is that a real issue or it is my configuration fail?

asked Jul 30 '15 at 19:17

aleks.n.fedorov

there is no simply "GMT" time zone, do you mean GMT+00:00? – Antonio Jul 30 '15 at 19:32
I mean simply GMT which is valid from Java point of view – aleks.n.fedorov Jul 30 '15 at 19:50
You might want to try `useLegacyDatetimeCode=false` instead – Mark Rotteveel Jul 31 '15 at 07:37

0 Answers0