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 protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
