[wp-hackers] Storing absolute time stamps
mark.wordpress at txfx.net
Mon Jun 25 16:14:59 GMT 2007
On Jun 25, 2007, at 8:55 AM, Omry Yadan wrote:
> I just saw that my server time zone is off by one hour, probably
> because of DST.
> so I changed the offset value in the admin page, refreshed the post
> page and nothing changed.
> I am guessing that the reason for that is that the absolute time is
> calculated when the comment is submitted, and stored as such.
> I suggest that we store UTC timestamp everywhere, and convert them
> before they are displayed.
Calculating the offset on the fly would allow offset changes to
invalidate the dates of previous comments and posts. Even worse, it
would break the permalinks of some posts. Say you posted something
at 0205 GMT with -03 offset. So 11:05pm "yesterday." If you change
the offset to -02, now the post is at 12:05am "today" Now the
permalink URL changes.
We store the GMT date and the local date, which is calculated as GMT
+ offset at the time the post was published. This is the same as us
storing GMT + offset per post. Either way it is two fields, and this
way involves less processing.
Covered Web Services
WordPress Ninja @ b5media Inc
More information about the wp-hackers