Re: [PHP] Holding "datetimes" in a DB.
[email protected] (tamouse mailing lists)
| Newsgroups | php.general |
|---|---|
| Message-ID | <CAHUC_t8i4jfMg3WDkR47spHURVW6CvNxoS8-oi6uKfJXEMm_Vw@mail.gmail.com> |
On Fri, Mar 1, 2013 at 11:53 AM, Matijn Woudt <[email protected]> wrote: > On Fri, Mar 1, 2013 at 11:49 AM, Richard Quadling <[email protected]>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.