RE: Does MySQL require patch for Daylight Savings Time 2007 change

["Jean-Sebastien Pilon" <jspilon@xxxxxxxxx>]

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:dcausevic@xxxxxxxxxxxx] 
> Sent: Wednesday, February 28, 2007 9:29 AM
> To: mysql@xxxxxxxxxxxxxxx
> 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 n?est 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 l?expé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 d?erreur puisque les informations qu?il 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/mysql?unsub=royale@xxxxxxxxxx