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
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
