| |
Don't forget to change your clocks... |
| |
rich (14:02 15/3/2010)
nunfetishist (14:20 15/3/2010)
rich (09:47 12/4/2010)
filecore (15:02 15/3/2010)
VincceH (18:25 15/3/2010)
Phlamethrower (19:20 15/3/2010)
VincceH (23:01 15/3/2010)
monkeyson2 (19:24 15/3/2010)
rich (21:20 15/3/2010)
filecore (21:22 15/3/2010)
|
| |
|
Richard Goodwin |
Message #113705, posted by rich at 14:02, 15/3/2010 |
 Dictator for life
Posts: 6828
|
I just had to restart the database. All the events on another website were screwed - instead of (e.g.)
* Wednesday, 7th April
they read
* Tuesday, 6th April to Wednesday, 7th April 10:59
Took me a few minute to realise - daylight savings time. They're stored as DATETIME in the DB, so they look fine checking manually (7th April 00:00 to 23:59), but the UNIXTIME call was returning GMT for events in the BST window, even though the MySQL website says it returns localtime. Adding one line of mysqld_safe configuration fixed it.
Doesn't help that I test the code on a Windows box (still with Apache/MySQL/PHP), which was working correctly.
________
 Cheers,
Rich.
|
| |
 [ Log in to reply ] |
| |
|
Rob Kendrick |
Message #113706, posted by nunfetishist at 14:20, 15/3/2010, in reply to message #113705 |
 Today's phish is trout a la creme.
Posts: 524
|
Oh, how we love MySQL. |
| |
[ Log in to reply ] |
| |
|
Jason Togneri |
Message #113712, posted by filecore at 15:02, 15/3/2010, in reply to message #113705 |
Posts: 3868
|
a Windows box [...] which was working correctly.  |
| |
[ Log in to reply ] |
| |
|
VinceH |
Message #113721, posted by VincceH at 18:25, 15/3/2010, in reply to message #113705 |
 Lowering the tone since the dawn of time
Posts: 1600
|
I had actually completely failed to notice that it was that time of year again - but on Sunday morning when I picked up my phone it informed me that the clock had been updated. Prompted by this, I then checked the one item I thought I'd need to update: my watch, but even that had updated itself.
Funny - I don't remember it being one of those watches that pick up a time signal, and nor do I remember it having some kind of built in function to automatically change to and from daylight savings time when necessary; neither of these things were listed as selling points when I bought it.
I also don't remember it changing automatically six months ago, or twelve months ago, or eighteen months ago (and so on), but then again, nor do I remember actually changing it myself.
This, of course, is not a site comment. Ho hum. |
| |
[ Log in to reply ] |
| |
|
Jeffrey Lee |
Message #113722, posted by Phlamethrower at 19:20, 15/3/2010, in reply to message #113721 |
 Hot Hot Hot Hot Hot Hot Hot Hot Hot Hot Hot Hot Hot stuff
Posts: 15100
|
(Psst - Your watch probably hasn't updated itself because BST doesn't start for another couple of weeks. And probably because it doesn't update itself automatically. No idea what's wrong with your phone though!  ) |
| |
[ Log in to reply ] |
| |
|
Phil Mellor |
Message #113723, posted by monkeyson2 at 19:24, 15/3/2010, in reply to message #113721 |
 Please don't let them make me be a monkey butler
Posts: 12380
|
Huh? It hasn't happened yet, surely?
http://www.direct.gov.uk/en/Governmentcitizensandrights/LivingintheUK/DG_073741
What time is it supposed to be now? I am confusored. |
| |
[ Log in to reply ] |
| |
|
Richard Goodwin |
Message #113724, posted by rich at 21:20, 15/3/2010, in reply to message #113723 |
Dictator for life
Posts: 6828
|
Last Sunday in March IIRC
________
Cheers,
Rich.
|
| |
[ Log in to reply ] |
| |
|
Jason Togneri |
Message #113725, posted by filecore at 21:22, 15/3/2010, in reply to message #113723 |
Posts: 3868
|
EDIT: snip stupidity
[Edited by filecore at 21:24, 15/3/2010] |
| |
[ Log in to reply ] |
| |
|
VinceH |
Message #113728, posted by VincceH at 23:01, 15/3/2010, in reply to message #113722 |
Lowering the tone since the dawn of time
Posts: 1600
|
(Psst - Your watch probably hasn't updated itself because BST doesn't start for another couple of weeks. And probably because it doesn't update itself automatically. No idea what's wrong with your phone though! ) Ah, I see - so what actually happened was that my phone strangely told me it had updated when it in fact hadn't. It lied to me.
I knew the change happens sometime in March, so I just accepted what it had said, and noting the time was right on the things that also update automatically, I assumed they had, well, updated. Automatically.
It was only the watch that threw me. (It's a very strong watch.) |
| |
[ Log in to reply ] |
| |
|
Richard Goodwin |
Message #113951, posted by rich at 09:47, 12/4/2010, in reply to message #113706 |
Dictator for life
Posts: 6828
|
Oh, how we love MySQL. OFC, I just had to change it back, presumably because someone fixed the initial problem.
________
Cheers,
Rich.
|
| |
[ Log in to reply ] |
| |
|
