i've been working on a new weblog-preference for specifying the timezone of a weblog. now it basically works, there's just one question i'd like to discuss: should we store timestamps in antville's database in GMT or keep it like it is (= local time)?

first options means that not only are timestamps in the database stored in GMT but also the appserver (just Helma, not the server) itself must run in GMT (specified in server.properties, specifying the timezone in apps.properties has no effect) - which means that every other app using the same Helma-installation is forced to adjust time according to a specified timezone itself.

second option means that antville will have to do a bit more of time-calculating (calc local time from DB back to GMT and then use the offset according to the specified timezone).

i tend to store timestamps in database in GMT, although this means that antville would get another default-property (the timezone of an antville-installation). and all existing timestamps in database must be converted to GMT. what ya think?