I believe we are storing UTC in the database now - Dave
On Sep 14, 2005, at 3:33 PM, Kolano, Kenneth M. wrote:
It might be best to convert things to UTC to start, and then provide
the
user options to convert those to their time zone. This would prevent
problems when a server was migrated from the East coast to the West
coast
and similar issues.
Kenneth M. Kolano
Enterprise Architecture Operations
908-423-4241
WS1B-51B
-----Original Message-----
From: Matthew Schmidt [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 14, 2005 3:28 PM
To: [email protected]
Subject: Re: VOTE: Pubtime Fix
This may or may not be related to this pubtime problem, but the issue
at
JRoller with weird pubtimes being set is due partially to the pubtime
being reliant on the User's timezone setting. On the frontpage, posts
are sorted by pubtime, mostly likely with the timezone of the server.
This means that posts from someone in Turkey will be in the future as
far as the server is concerned and not find their way to the frontpage.
The same holds true with timezones in the past (a more serious issue),
these posts never even make it to the frontpage. Is there a way that
we
can normalize things somewhere so that the server converts all pubtimes
to the server's timezone while still letting the user post with their
set timezone? If we set the pubtime to the server timezone, this would
likely confuse the user, so I think it has to be a lower level.
Thoughts?
-Matt
Dave Johnson wrote:
+1
We've had many complaints about this one and I myself have been bitten
by Roller's odd-behavior here in the past.
- Dave
On Sep 14, 2005, at 3:02 PM, Allen Gilliland wrote:
This is a very small feature/fix so I think we can do the proposal
and vote all at the same time.
http://www.rollerweblogger.org/wiki/Wiki.jsp?page=Proposal_PubtimeFix
Full details on the proposal page above.
The real short version is that BSC users have been complaining a lot
about the fact that the pubtime for entries is not actually set to
the "publish" time when you start from a draft or take a long time
writing your entry. To fix this we can have the pubtime remain unset
(null) until the entry is actually published for the first time, at
which point we set it to the current date/time.
this will go into 2.0
-- Allen
-----------------------------------------------------------------------
-------
Notice: This e-mail message, together with any attachments, contains
information of Merck & Co., Inc. (One Merck Drive, Whitehouse Station,
New Jersey, USA 08889), and/or its affiliates (which may be known
outside the United States as Merck Frosst, Merck Sharp & Dohme or MSD
and in Japan, as Banyu) that may be confidential, proprietary
copyrighted and/or legally privileged. It is intended solely for the
use of the individual or entity named on this message. If you are not
the intended recipient, and have received this message in error,
please notify us immediately by reply e-mail and then delete it from
your system.
-----------------------------------------------------------------------
-------
