Re: timestamp mysql oddity
Re: timestamp mysql oddity
- Subject: Re: timestamp mysql oddity
- From: Lachlan Deck <email@hidden>
- Date: Mon, 18 Aug 2008 10:16:44 +1000
On 17/08/2008, at 9:40 AM, Johann Werner wrote:
Looking at wikipedia it says BST = British Summer Time UTC+1h which
means that your system time is (correctly) set to your local
timezone in London. The default time zone for MySQL is your system
time zone so it will save timestamps accordingly. In your first post
you noted that a timestamp gets incremented by one hour. Your
example had a timestamp that was GMT so converting it to BST results
in adding one hour. (I assume that the year 22009 was a typo)
There is a bug in the jdbcadaptor where it ignores the timezone you
want without various overrides. My jdbc adaptor url looks like this:
....?
autoReconnect
=
true
&zeroDateTimeBehavior
=
convertToNull
&useGmtMillisForDatetimes=true&useTimezone=true&serverTimezone=foo
i.e., where foo equals the timezone you've set for your database
(which is hopefully GMT but for legacy reasons ours is Australia/
Sydney, for example)
with regards,
--
Lachlan Deck
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden