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 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/[EMAIL PROTECTED]

Reply via email to