2013/3/2 tamouse mailing lists <tamouse.li...@gmail.com>
> On Fri, Mar 1, 2013 at 11:53 AM, Matijn Woudt <tijn...@gmail.com> wrote:
> > On Fri, Mar 1, 2013 at 11:49 AM, Richard Quadling <rquadl...@gmail.com
> >> Hi.
> >> My heads trying to remember something I may or may not have known to
> >> with.
> >> If I hold datetimes in a DB in UTC and can represent a date to a user
> >> based upon a user preference Timezone (not an offset, but a real
> >> timezone : Europe/Berlin, etc.) am I missing anything?
> >> Richard.
> > I would only use this if you're planning to have servers all around the
> > world in different timezones, then it would be easier to interchange
> > Otherwise, stick with ur local timezone and it will save you a lot of
> > unneeded timezone conversions probably.
> > - Matijn
> This may be just me, but I've always preferred my servers, database,
> and such to run UTC, and let users select their own time zone they'd
> like to see.
Well, imo it depends ;) There are cases, where it is interesting to know,
when from the users point of view they have created the entity (like a blog
post, a comment, or something like that). The TZ is part of the data and
converting it silently to UTC is always data-loss. So in most cases it is
OK, but not in every :) You can still convert from entity-TZ to UTC to
user-TZ later. Its just one additional step.
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php