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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
