log in | register | forums
Show:
Go:
Forums
Username:

Password:

User accounts
Register new account
Forgot password
Forum stats
List of members
Search the forums

Advanced search
Recent discussions
- WROCC Newsletter Volume 41:11 reviewed (News:)
- WROCC March 2024 meeting o... Hughes and Peter Richmond (News:1)
- Rougol March 2024 meeting on monday with Bernard Boase (News:)
- Drag'n'Drop 13i2 edition reviewed (News:)
- South-West Show 2024 talks (News:4)
- February 2024 News Summary (News:1)
- Next developer fireside chat (News:)
- DDE31d released (News:)
- South-West Show 2024 Report (News:)
- South-West Show 2024 in pictures (News:)
Latest postings RSS Feeds
RSS 2.0 | 1.0 | 0.9
Atom 0.3
Misc RDF | CDF
 
View on Mastodon
@www.iconbar.com@rss-parrot.net
Site Search
 
Article archives
The Icon Bar: Site Comments: Don't forget to change your clocks...
 
  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
Rich
Dictator for life
Posts: 6824
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.
________
RichGCheers,
Rich.
  ^[ Log in to reply ]
 
Rob Kendrick Message #113706, posted by nunfetishist at 14:20, 15/3/2010, in reply to message #113705
nunfetishist
Today's phish is trout a la creme.

Posts: 522
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: 3867
a Windows box [...] which was working correctly.
shock
  ^[ Log in to reply ]
 
VinceH Message #113721, posted by VincceH at 18:25, 15/3/2010, in reply to message #113705
VincceH
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
PhlamethrowerHot 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! tongue)
  ^[ Log in to reply ]
 
Phil Mellor Message #113723, posted by monkeyson2 at 19:24, 15/3/2010, in reply to message #113721
monkeyson2Please 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
Rich
Dictator for life
Posts: 6824
Last Sunday in March IIRC
________
RichGCheers,
Rich.
  ^[ Log in to reply ]
 
Jason Togneri Message #113725, posted by filecore at 21:22, 15/3/2010, in reply to message #113723

Posts: 3867
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
VincceH
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! tongue)
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
Rich
Dictator for life
Posts: 6824
Oh, how we love MySQL.
OFC, I just had to change it back, presumably because someone fixed the initial problem.
________
RichGCheers,
Rich.
  ^[ Log in to reply ]
 

The Icon Bar: Site Comments: Don't forget to change your clocks...