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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]
>>> Sent: Saturday, February 24, 2007 4:28 PM
>>> To: mysql@lists.mysql.com
>>> 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/[EMAIL PROTECTED]
>>>
>>>
>>>
>>
>>
>>
>>
>>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
