From: Date: March 1 2007 1:09am Subject: Re: MySQL Daylight Savings Time Patch - easy check List-Archive: http://lists.mysql.com/mysql/205304 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_20289_10092706.1172707779677" ------=_Part_20289_10092706.1172707779677 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline That was interesting. I have 2 rhel 3 servers and they both have been update to handle the DST. They both yield different results when I ran the command: SERVER=RALPH +---------------------------------------+---------------------------------------+ | UNIX_TIMESTAMP('2007-03-11 02:00:00') | UNIX_TIMESTAMP('2007-03-11 03:00:00') | +---------------------------------------+---------------------------------------+ | 1173607200 | 1173610800 | +---------------------------------------+--------------------------------------- and this for the other server : SERVER=MAGGIE +---------------------------------------+---------------------------------------+ | UNIX_TIMESTAMP('2007-03-11 02:00:00') | UNIX_TIMESTAMP('2007-03-11 03:00:00') | +---------------------------------------+---------------------------------------+ | 1173607200 | 1173607200 | +---------------------------------------+--------------------------------------- Uhmmmmm............. Nestor On 2/28/07, William R. Mussatto wrote: > > On Wed, February 28, 2007 14:10, Ryan Stille said: > > I am on 4.1.20-1. > > > > Maybe your OS isn't patched? > > > > Try this: "SELECT @@global.time_zone;" > Won't help if you are on debian which is still on 4.0. > > If you get back "SYSTEM", then MySQL is looking to the OS for timezone > > data. And its only loaded when MySQL starts, so if you haven't > > restarted MySQL since you patched your OS, you need to do that. > > > > -Ryan > > > > Jerry Schwartz wrote: > >> What version of MySQL are you using? I'm running 4.1.21, and that check > >> doesn't work even after I've updated (I think) the time zone tables. > >> > >> I should probably eyeball the output of mysql_tzinfo_to_sql. > >> > >> Regards, > >> > >> Jerry Schwartz > >> Global Information Incorporated > >> 195 Farmington Ave. > >> Farmington, CT 06032 > >> > >> 860.674.8796 / FAX: 860.674.8341 > >> > >> > >> > >>> -----Original Message----- > >>> From: Ryan Stille [mailto:ryan@stripped] > >>> Sent: Saturday, February 24, 2007 4:28 PM > >>> To: mysql@stripped > >>> Subject: Re: MySQL Daylight Savings Time Patch - easy check > >>> > >>> Ryan Stille wrote: > >>> > >>>> Paul DuBois wrote: > >>>> > >>>>> At 4:40 PM -0600 2/20/07, Ryan Stille wrote: > >>>>> > >>>>>> Is there an easy way to test to see if MySQL already has > >>>>>> > >>> the proper > >>> > >>>>>> tables loaded? > >>>>>> > >>>>>> -Ryan > >>>>>> > >>>>> Yes, reload them. :-) After that, they're current! ....... > >>>>> > >>>>> > >>> After digging around on the net for a while I found an easy > >>> way to tell > >>> if your MySQL installation is ready for the new daylight savings time. > >>> > >>> SELECT UNIX_TIMESTAMP('2007-03-11 02:00:00'), > >>> UNIX_TIMESTAMP('2007-03-11 03:00:00'); > >>> > >>> This should return the same value, even though you are feeding it > >>> different times, because this is when the 1 hr change occurs. > >>> I get the > >>> correct result on both of my machines. On one of them I've run the > >>> suggested |mysql_tzinfo_to_sql command, on the other, the time zone > >>> tables are completely empty! > >>> > >>> Any wisdom on these time zone tables - are they ever used, should I > >>> populate them or not? > >>> > >>> -Ryan > >>> > >>> | > >>> > >>> > >>> -- > >>> MySQL General Mailing List > >>> For list archives: http://lists.mysql.com/mysql > >>> To unsubscribe: > >>> http://lists.mysql.com/mysql?unsub=jschwartz@stripped > >>> > >>> > >>> > >> > >> > >> > >> > >> > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql?unsub=mussatto@stripped > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=rotsen@stripped > > ------=_Part_20289_10092706.1172707779677--