RE: Does MySQL require patch for Daylight Savings Time 2007 change

2007-03-13 Thread Jerry Schwartz
: 860.674.8341 -Original Message- From: gladius pauline [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 13, 2007 3:04 PM To: Jerry Schwartz Subject: RE: Does MySQL require patch for Daylight Savings Time 2007 change Thanks a lot and i tried show variables like '%time%'; i got

Does MySQL require patch for Daylight Savings Time 2007 change

2007-02-28 Thread Causevic, Dzenan
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? ___ Dzenan Causevic Web Applications Developer NaviSite, Inc. 315-453-2912 x5346 (Office)

re: Does MySQL require patch for Daylight Savings Time 2007 change

2007-02-28 Thread J.R. Bullington
, 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

RE: Does MySQL require patch for Daylight Savings Time 2007 change

2007-02-28 Thread Jean-Sebastien Pilon
, 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

FW: Does MySQL require patch for Daylight Savings Time 2007 change

2007-02-28 Thread Causevic, Dzenan
(Office) 315-278-7371 (Cell) www.NaviSite.com -Original Message- From: J.R. Bullington [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 9:40 AM To: mysql@lists.mysql.com Subject: re: Does MySQL require patch for Daylight Savings Time 2007 change As far

RE: Does MySQL require patch for Daylight Savings Time 2007 change

2007-02-28 Thread Jean-Sebastien Pilon
-453-2912 x5346 (Office) 315-278-7371 (Cell) www.NaviSite.com -Original Message- From: J.R. Bullington [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 9:40 AM To: mysql@lists.mysql.com Subject: re: Does MySQL require patch for Daylight Savings Time 2007 change

RE: Does MySQL require patch for Daylight Savings Time 2007 change

2007-02-28 Thread Jerry Schwartz
, Dzenan; mysql@lists.mysql.com Subject: RE: Does MySQL require patch for Daylight Savings Time 2007 change I don't believe so, since the version of MySQL you are using relies on the system's time. I am using 4.1 and I am setup to use system's time and my timezone tables in the mysql schema

RE: Does MySQL require patch for Daylight Savings Time 2007 change

2007-02-28 Thread Jean-Sebastien Pilon
: Does MySQL require patch for Daylight Savings Time 2007 change Hang on a second! Doesn't EST transition to DST at 03:00? Shouldn't that query (the one for testing MySQL's time zones) be SELECT UNIX_TIMESTAMP('2007-03-11 02:00:00'),UNIX_TIMESTAMP('2007-03-11 03:00:00

RE: Does MySQL require patch for Daylight Savings Time 2007 change

2007-02-28 Thread Jerry Schwartz
12:53 PM To: mysql@lists.mysql.com Subject: RE: Does MySQL require patch for Daylight Savings Time 2007 change You have both compare 0100 vs 0200 and 0200 vs 0300 in my reply... It wasn't clear because of emails being wrapped at 80 chars. And it still doesn't work after loading the tables

RE: Does MySQL require patch for Daylight Savings Time 2007 change

2007-02-28 Thread Jean-Sebastien Pilon
You ran your zdump -v against this file ? -Original Message- From: Jerry Schwartz [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 1:41 PM To: Jean-Sebastien Pilon; mysql@lists.mysql.com Subject: RE: Does MySQL require patch for Daylight Savings Time 2007 change

RE: Does MySQL require patch for Daylight Savings Time 2007 change

2007-02-28 Thread Jerry Schwartz
-Original Message- From: Jean-Sebastien Pilon [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 2:37 PM To: Jerry Schwartz; mysql@lists.mysql.com Subject: RE: Does MySQL require patch for Daylight Savings Time 2007 change You ran your zdump -v against this file ? -Original