Patches to deal with changes to U.S. Daylight Savings Time?

[SantaMufasa]

Beginning 2007, U.S. Daylight Savings Time occurs the second Sunday in March and ends the first Sunday in November, adding four weeks to daylight saving time.

Can anyone direct me to links (or other definitive information) that confirms what patches (or other preventative/remedial) actions we must take to avoid problems, at the database level, resulting from this adjustment?

Thanks,


Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[r937]

i understand the question, but i don't understand why you're asking it

as far as the database is concerned, setting the clock forward or backward one hour has been happening for years, so if you didn't have a "patch" in place earlier this year, did you have a problem? if not, how is setting the clock on a different day going to introduce a new problem?

r937.com | rudy.ca

 

[SantaMufasa]

Rudy,

We run several MySQL, Oracle, SQL Server, EnterpriseDB, and DB2 installations. In some of those database-vendor environments, the database software provides date-related functionality beyond that which depends simply upon accessing operating-system date registers.

As a result of these DST changes (called for in the Energy Act of 2005), if the DBA does not apply to the database-software installation itself appropriate related vendor patches, the database may report incorrect time zone data between 03/11/2007 – 04/01/2007 and between 10/28/2007 – 11/04/2007 (and on different dates in subsequent years).

I infer from your reply that you assert that MySQL does not call for any patches that affect database functionality (beyond MySQL's access to the operating system's date register(s)).

Do you have any definitive references/links from any MySQL vendor that confirm that MySQL requires no special patching to accommodate proper DST handling? Our auditors require a definitively referenceable source that confirms that we have no special patching that needs to occur on MySQL installations.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[r937]

took a quick peek at the mysql docs and found this --

http://dev.mysql.com/tech-resources/articles/4.1/time.html

http://dev.mysql.com/doc/refman/4.1/en/time-zone-support.html

http://dev.mysql.com/downloads/timezones.html

other than that, i ain't assertin' nuttin' ;-)

r937.com | rudy.ca