I'm curious about how MySQL deals with time zones. Our machines are located in the GMT time zone, and recently rolled over to British Standard Time (local daylight savings time). The MySQL installation has started returning NOW() values in local time, not GMT. Is this the way the database is designed to work? With no time zone sub-field in date and/or time fields, how are you supposed to deal with a clock which, because of daylight savings time, will move an hour back in time once a year?
What does the SQL standard say about time zones and functions like NOW(), upon what standards has the database community converged for dealing with time zones, and how can MySQL be configured to provide consistent (not affected by daylight savings time) values for NOW()? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
