Version < 4.1.3 -> relies on the O/S for DST Quote from http://dev.mysql.com/doc/refman/4.1/en/time-zone-support.html
"For versions of MySQL older than 4.1.3 that do not have time zone support, the server always tracks the operating system time (much like a time zone setting of SYSTEM in 4.1.3 and up). Assuming that the server host itself has its operating system updated to handle any changes to Daylight Saving Time rules, the MySQL server should know the correct time." Version => 4.1.3 -> DST is set in the DBMS Quote from http://dev.mysql.com/doc/refman/4.1/en/time-zone-support.html "The operating system time affects the value that the MySQL server uses for times if its time zone is set to SYSTEM. Make sure that your operating system is using the latest time zone information. For most operating systems, the latest update or service pack prepares your system for the time changes. Check the Web site for your operating system vendor for an update that addresses the time changes. If your system draws its time from a public clock on the internet, it should adjust the time automatically." > -----Original Message----- > From: Causevic, Dzenan [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 28, 2007 9:29 AM > To: mysql@lists.mysql.com > Subject: Does MySQL require patch for Daylight Savings Time > 2007 change > > I am running Apache HTTP 1.3 with PHP 4.2.2 and MySQL 3.23. > > Do I need to apply any kind of patches to my MySQL related to Daylight > Savings Time 2007 change? > NOTICE: This email contains privileged and confidential information and is intended only for the individual to whom it is addressed. If you are not the named addressee, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this transmission by mistake and delete this communication from your system. E-mail transmission cannot be guaranteed to be secured or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. AVIS: Le présent courriel contient des renseignements de nature privilégiée et confidentielle et nest destiné qu'à la personne à qui il est adressé. Si vous nêtes pas le destinataire prévu, vous êtes par les présentes avisés que toute diffusion, distribution ou reproduction de cette communication est strictement interdite. Si vous avez reçu ce courriel par erreur, veuillez en aviser immédiatement lexpéditeur et le supprimer de votre système. Notez que la transmission de courriel ne peut en aucun cas être considéré comme inviolable ou exempt derreur puisque les informations quil contient pourraient être interceptés, corrompues, perdues, détruites, arrivées en retard ou incomplètes ou contenir un virus. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
