Hi all, I've been debugging a problem we've got where the fetched timestamp is 1 hour out for times that fall after (or close after) the date when day light savings comes off.
Viewing the data in mysql the times are correct for Sydney (unfortunately the deployment db is not in UTC but Australia/Sydney time... out of my hands). When fetching a list of records all of them have the same endTimestamp value .. but once we have an NSTimestamp the last record which falls over the boundary is wrong. So I experimented by created another field on the entity which maps to the same external field (as a read-only field) and utilising a custom class (ISHDate) with factory method 'parseDate(String)' to see what's coming in... and it's wrong there too. I've played with various mysql jconnector params to see what happens. ...&zeroDateTimeBehavior=convertToNull ...&useGmtMillisForDatetimes=true ...&useTimezone=true&serverTimezone=Australia/Sydney ...&useLegacyDatetimeCode=true And I've updated all the zoneinfo stuff to the latest on my system and in all the jars/frameworks. Still no good. Further suggestions? Cheers. 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]
