[wp-hackers] Storing absolute time stamps
omry at yadan.net
Mon Jun 25 14:00:28 GMT 2007
James Davis wrote:
> Omry Yadan wrote:
>> I suggest that we store UTC timestamp everywhere, and convert them
>> before they are displayed.
> Not everyone has a constant offset from their server's time.
people with changing time offset have bigger problems than this.
> Your suggestion would retrospectively change the displayed times of
> posts which were correct at the time the post was made.
> If the times your posts are incorrect, the fix is to alter the times of
> the posts.
if the time of the posts is in UTC, its always correct.
keeping the time as UTC will also allow showing different time to
different users, based on their time zone. (assuming some way for the
users to specify their time zones).
More information about the wp-hackers