Arjen,
So how do you feel about the idea of scrapping timezones from the db altogether? (talking technical/practical merit, of course it's sad tossing out lots of work ;-)
Well, the real question is how well does it work now? You can sink an infinite amount of work into fixing up a conceptually flawed codebase.
As others on this list do, I think the sensible thing is to store timestamps in UTC and display them in the client's current time zone unless the user explicitly says otherwise with an "at time zone" clause.
I think it's also a good idea to accept timestamps at a particular time zone, but convert them to UTC before storage.
--Josh _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
