I'd actually caution against GMT in favor of UTC. GMT has summer time, aka daylight saving time (DST).
-Sheeri On 7/23/08, Arjen Lentz <[EMAIL PROTECTED]> wrote: > > Hi, > > I saw votes for storing in GMT and just picking up what the OS does for > conversions. > While that is fairly sane, I'd suggest to force further simplification. > > I have for years forced all my servers to actually run in GMT0, this just > prevents so many problems. > If an application wants to show something in a local timezone, that's fine > and it sorts it out. > The timezone of the server is largely irrelevant. Look, if you have users, > they're likely to be in multiple different timezones. So which one is the > right one? How many companies actually maintain a special standard time? And > does that make sense for users? > eBay does have its standard eBay time, however it's a pest to deal with; > standard eBay time in Australia is in Sydney, however I'm in Queensland and > we don't have daylight savings here. So for part of the year I'm off by an > hour - but the eBay site won't tell me that so I can actually miss out on > information, even though the eBay system knows exactly where I am. > > So, after that rant, I would contend that the system time is as irrelevant > as everything else, the only thing that MIGHT matter is the user's timezone, > and since that can be anything, the db cannot possibly deal with it. In that > context, just dealing with GMT would be best. > I'll grant ya that if we stick with the OS conversion, if I set my server > to GMT0, that should be accomplished - in theory! > > However, I'm wondering if the stuff can possibly break on input, depending > on the user timezone? What goes in is not OS timezone, it's application (or > user) timezone. The only thing who knows about that is the application, so > therefore IT should deal with the conversion to GMT, not the database. Just > like in the old days, the server (and db) should not try to be too smart, > otherwise you get double conversions and borked times. > > So what I would really *prefer* is a strict policy of no conversion at all > in Drizzle. > Making sense or is my logic flawed (it may well be, it's late here) > > > Regards, > Arjen. > -- > Arjen Lentz, Founder @ Open Query > Training and Expertise for MySQL in Australia and New Zealand > http://openquery.com.au/training/ (ph. +61-7-3103 0809) > > > > > > > _______________________________________________ > Mailing list: > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > Post to : [email protected] > Unsubscribe : > https://launchpad.net/~drizzle-discuss<https://launchpad.net/%7Edrizzle-discuss> > More help : https://help.launchpad.net/ListHelp > -- - Sheeri K. Cabral Note: Currently I work for The Pythian Group (http://www.pythian.com/ ), a remote DBA firm, and consulting would constitute a conflict of interest. However, I do recommend our work, and if you're looking for DBA work (I do MySQL work, but they have great Oracle and SQL Server DBAs too) right now, whether you need a few hours a week, or someone fulltime while you continue a job search. I have a webpage with tips on how to find a DBA: http://sheeri.net/how-to-find-a-dba/ I can recommend http://www.toomanyconnections.com as a good site to find MySQL (and Oracle) DBAs. If you're looking for web design, I recommend the small business my husband works for, http://www.digital-loom.com I regret that I have no other information for any other type of position, including developer, programmer and systems administrator.
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
