[Novalug] MySQL time does not match system time

jecottrell3@comcast.net jecottrell3@comcast.net
Wed Apr 7 14:58:59 EDT 2010


I would say that your solution is only marginally saner than Terry Kath's last action.

How long is this expected to work for? You need a beginning and ending window dates in which to apply this correction ... the rest of the time it will produce the wrong results.

To answer your question, the TZ correction needs to be put on the MySQL server if MySQL is doing the correction.


JIM

P.S. Wikipedia says that Kath's wife rewed Keifer Sutherland. 24 or 6 to 5?

----- Original Message -----
From: "Mike McFadden" <MMcFadden@agu.org>
To: novalug@calypso.tux.org
Sent: Wednesday, April 7, 2010 10:27:51 AM GMT -05:00 US/Canada Eastern
Subject: Re: [Novalug] MySQL time does not match system time

Sing some more Chicago! I fixed it ~ it's a total hack, but works for me... in my script/SQL I made this change : DATE_ADD(NOW(), INTERVAL 1 HOUR) Thanks for all the advice!

Mike

-----Original Message-----
From: jecottrell3@comcast.net [mailto:jecottrell3@comcast.net] 
Sent: Tuesday, April 06, 2010 6:27 PM
To: Peter Larsen
Cc: novalug@calypso.tux.org; Mike McFadden
Subject: Re: [Novalug] MySQL time does not match system time

And this is a problem WHY? Internally, the time is correct. What difference does it make if dates are listed as

Tue Apr  6 17:11:00 EST 2010 rather than
Tue Apr  6 18:11:00 EDT 2010 for a few weeks?

Geeze...run your servers on GMT...or move to Arizona.

More seriously, set TZ=EDT4 for as long as you need to.

JIM

P.S. I never did set my car clock last fall ... now it's correct again.

P.P.S. Does anybody really know what time it is? Does anybody really care?

----- Original Message -----
From: "Peter Larsen" <plarsen@famlarsen.homelinux.com>
To: "Mike McFadden" <MMcFadden@agu.org>
Cc: novalug@calypso.tux.org
Sent: Tuesday, April 6, 2010 2:42:32 PM GMT -05:00 US/Canada Eastern
Subject: Re: [Novalug] MySQL time does not match system time

On Tue, 2010-04-06 at 14:15 -0400, Mike McFadden wrote:
> Hi All,
> 
> I have searched and searched the internet for a solution to this problem with no luck and I'm stuck. I am running SuSE 10 and I reset the time when we went to daylight time. It is correct now:

Looks like mySQL has it's own timezone database
(http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html).
Following a few entries it could be that your timezone database is out
of sync with reality and hence needs updating
(http://dev.mysql.com/tech-resources/articles/daylight-saving-time-changes.html).

There's a lot of information of what you should check/do on the first
link. I would start there.

-- 
Best Regards
  Peter Larsen

Wise words of the day:
* SynrG notes that the number of configuration questions to answer in sendmail
  is NON-TRIVIAL
	-- Seen on #Debian

_______________________________________________
Novalug mailing list
Novalug@calypso.tux.org
http://calypso.tux.org/mailman/listinfo/novalug
_______________________________________________
Novalug mailing list
Novalug@calypso.tux.org
http://calypso.tux.org/mailman/listinfo/novalug



More information about the Novalug mailing list