Re: [PHP] Holding "datetimes" in a DB.

2013-03-02 Thread Lester Caine
Paul McGarry wrote: 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?

Re: [PHP] Holding "datetimes" in a DB.

2013-03-01 Thread Paul McGarry
On Fri, Mar 1, 2013 at 9:49 PM, Richard Quadling 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 > timez

Re: [PHP] Holding "datetimes" in a DB.

2013-03-01 Thread Nick Whiting
On Fri, Mar 1, 2013 at 7:04 PM, Sebastian Krebs wrote: > 2013/3/2 tamouse mailing lists > > > On Fri, Mar 1, 2013 at 11:53 AM, Matijn Woudt wrote: > > > On Fri, Mar 1, 2013 at 11:49 AM, Richard Quadling > >wrote: > > > > > >> Hi. > > >> > > >> My heads trying to remember something I may or may

Re: [PHP] Holding "datetimes" in a DB.

2013-03-01 Thread Sebastian Krebs
2013/3/2 tamouse mailing lists > On Fri, Mar 1, 2013 at 11:53 AM, Matijn Woudt wrote: > > On Fri, Mar 1, 2013 at 11:49 AM, Richard Quadling >wrote: > > > >> Hi. > >> > >> My heads trying to remember something I may or may not have known to > start > >> with. > >> > >> If I hold datetimes in a D

Re: [PHP] Holding "datetimes" in a DB.

2013-03-01 Thread tamouse mailing lists
On Fri, Mar 1, 2013 at 11:53 AM, Matijn Woudt wrote: > On Fri, Mar 1, 2013 at 11:49 AM, Richard Quadling 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 up

Re: [PHP] Holding "datetimes" in a DB.

2013-03-01 Thread Matijn Woudt
On Fri, Mar 1, 2013 at 11:49 AM, Richard Quadling 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 > timez

Re: [PHP] Holding "datetimes" in a DB.

2013-03-01 Thread Lester Caine
Richard Quadling wrote: 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?

Re: [PHP] Holding "datetimes" in a DB.

2013-03-01 Thread Simon Schick
Hi, Richard I, too, tought about switching to UTC times in my database. The only reason for me was to get prepared for globalisation. A good article about this consideration is written at PHP Gangsta (sorry, German only): http://www.phpgangsta.de/die-lieben-zeitzonen The reason, why I did not sw