>>In MySQL Workbench I can choose the local Server, or a web server. If I choose the local version of course it will use the local date. There's no other option.
>>I would expect to expect the web server version to use the remote date.
>
>That might be odd. A remote serve in a different time zone could be a day wrong ...
I had a near snafu with such a setup. The server was in Texas but the time set was pacific, which was odd... and reminded me of how all PCs are born in pacific timezone, and I knew it was a brand new box and everything installed with defaults left intact. I almost wrestled my way through privileges to fix that, when a colleague chimed in and said the server is set for a client in San Francisco... ouch. So the timezone was okay, only most of the rest was wrong :).