Hello.
The good support of timezones is on TODO list. See:
http://dev.mysql.com/doc/mysql/en/todo-future.html
"Monty Harris" <[EMAIL PROTECTED]> wrote:
> How does one cope with time zones? For example, if I want to timestamp a
> record it will timestanp using the local time of my server. I thought that,
> e.g if my server was in New York and my customer_location was the UK, I can
> just add 5 hours to the time and it would be correct.
>
> While that might work for 51 weeks of the year, how do we cope with the one
> week where the clocks in the UK go forward one week earlier than they do in
> the USA, as just happened a few weeks ago?
>
> How can we reliably handle multiple time zones, and daylight savings time,
> with one server located in one location? Am I asking the impossible?
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
