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

Reply via email to