OK; this is what I was after agrees with what I thought. We should include
it in the docs. I will start to document this on the wiki and to propose an
effort to clean things up, and possibly localize some of the logic needed to
observe the rules.
My particular concerns are these:
- I'd like to use UTC uniformly for storage, but I'm not sure we are. We
may be using the server's default timezone.
- In some places (for example the pager code I recently was looking at) I
see default timezone use of Calendar.getInstance() rather than explicitly
specifying the GMT timezone.
- I believe different JDBC drivers / databases handle the conversion of
internal UTC millisecond value in java.sql.Date / Timestamp differently, so
in order to store things in UTC uniformly, additional instructions in
configuration may also be required.
----- Original Message -----
From: "Dave" <[EMAIL PROTECTED]>
To: <roller-dev@incubator.apache.org>
Sent: Monday, December 04, 2006 6:34 AM
Subject: Re: timezone treatment
I don't think we have timezone handling documented anywhere.
Here's how I think things work:
- Each weblog has a timezone
- Each user has a timezone
(Used only as default when user creates a new weblog)
- Dates are stored in a timezone free universal format (UTC?)
- When displayed on a weblog, entry dates are converted to weblog's
timezone
- In weblog entry form, date are displayed and processed in weblog's
timezone
- Incoming MetaWeblog API posts include date with timezone and Java
date parsing converts them to universal format for storage.
- Dave
On 12/3/06, Anil Gangolli <[EMAIL PROTECTED]> wrote:
Do we have a clear description of our treatment of timezone anywhere?
I think we have several minor timezone-related bugs, but before looking
at them, I'd like to make sure we first have a consistent proposal for
how timezone should be treated.
--a.
