Re: Holding "datetimes" in a DB.

On Fri, Mar 1, 2013 at 11:53 AM, Matijn Woudt <tijnema@gmail.com> wrote: > On Fri, Mar 1, 2013 at 11:49 AM, Richard Quadling <rquadling@gmail.com>wrote: > >> Hi. >> >> My heads trying to remember something I may or may not have known to start >> 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 data. > 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.