Re: TimeZone conversion in Connector/J; maybe a patch is in order?

[John Bishop]

Ok, I think I know what the problem is... I should've blamed my inexperience instead of the connector. I was using useTimezone, but I was also specifying the same timezone for serverTimezone that the calendar object that I was using with getTimestamp was configured for. Net result was that one cancelled out the other, and it seemed like the parameter was being ignored. My bad.

The documentation (Java API docs, and to a lesser extent the MySQL/J docs) could probably stand to be clearer on how things work... I get the feeling though that this isn't a common scenario.

Thanks for the help, regardless.