List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 20 2007 11:17pm
Subject:RE: MySQL Daylight Savings Time Patch
View as plain text  
At 4:36 PM -0500 2/20/07, Sun, Jennifer wrote:
>Any answers for the question below ?
>
>Is there a DST patch for MySql 4.0.20?   Thanks.
>
>-----Original Message-----
>From: dpgirago@stripped [mailto:dpgirago@stripped]
>Sent: Friday, February 09, 2007 9:30 AM
>To: mysql@stripped
>Subject: MySQL Daylight Savings Time Patch
>
>Is there a DST patch for MySQL 4.0.x series?
>
>I've been getting scary emails from our sys and net admins about
>impending
>doom.
>
>Thanks,
>
>David

Before MySQL 4.1.3, the server gets its time zone from the operating system
at startup.  The time zone can be specified explicitly by setting the TZ
TZ environment variable setting, or by using the --timezone option to the
mysqld_safe server startup script.

Assuming that the server host itself has had its operating system updated
to handle the new Daylight Saving Time rules, that should be all that's
necessary for MySQL to know the correct time.

-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Thread
MySQL Daylight Savings Time Patchdpgirago9 Feb
  • RE: MySQL Daylight Savings Time PatchJennifer Sun20 Feb
    • Re: MySQL Daylight Savings Time PatchChris White20 Feb
      • Re: MySQL Daylight Savings Time PatchDan Buettner20 Feb
        • RE: MySQL Daylight Savings Time PatchJennifer Sun20 Feb
  • Re: MySQL Daylight Savings Time PatchAaron Cannon21 Feb
  • Re: MySQL Daylight Savings Time Patch - easy checkMike Blezien24 Feb
    • Re: MySQL Daylight Savings Time Patch - easy checkRyan Stille24 Feb
  • Re: MySQL Daylight Savings Time Patch - easy checkMike Blezien24 Feb
RE: MySQL Daylight Savings Time PatchPaul DuBois20 Feb
  • RE: MySQL Daylight Savings Time PatchPaul DuBois20 Feb
    • Re: MySQL Daylight Savings Time PatchRyan Stille20 Feb
      • Re: MySQL Daylight Savings Time PatchPaul DuBois20 Feb
        • Re: MySQL Daylight Savings Time PatchRyan Stille24 Feb
          • Re: MySQL Daylight Savings Time PatchRyan Stille24 Feb
          • Re: MySQL Daylight Savings Time Patch - easy checkRyan Stille24 Feb
            • Re: MySQL Daylight Savings Time Patch - easy check(Terry Riley)25 Feb
            • RE: MySQL Daylight Savings Time Patch - easy checkJerry Schwartz28 Feb
              • Re: MySQL Daylight Savings Time Patch - easy checkRyan Stille28 Feb
                • Re: MySQL Daylight Savings Time Patch - easy checkWilliam R. Mussatto28 Feb
                  • Re: MySQL Daylight Savings Time Patch - easy checkNĂ©stor1 Mar
                    • Re: MySQL Daylight Savings Time Patch - easy checkRyan Stille1 Mar
                • RE: MySQL Daylight Savings Time Patch - easy checkJerry Schwartz1 Mar
                • RE: MySQL Daylight Savings Time Patch - easy checkJerry Schwartz1 Mar
  • RE: MySQL Daylight Savings Time PatchJerry Schwartz21 Feb
RE: MySQL Daylight Savings Time PatchPaul DuBois20 Feb
  • RE: MySQL Daylight Savings Time PatchJerry Schwartz21 Feb