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 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

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 Matijn Woudt
On Fri, Mar 1, 2013 at 11:49 AM, Richard Quadling rquadl...@gmail.comwrote: 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

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 tijn...@gmail.com wrote: On Fri, Mar 1, 2013 at 11:49 AM, Richard Quadling rquadl...@gmail.comwrote: 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

Re: [PHP] Holding datetimes in a DB.

2013-03-01 Thread Sebastian Krebs
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 wrote: Hi. My heads trying to remember something I may or may not have known to start

Re: [PHP] Holding datetimes in a DB.

2013-03-01 Thread Nick Whiting
On Fri, Mar 1, 2013 at 7:04 PM, Sebastian Krebs krebs@gmail.com wrote: 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 wrote: Hi.

Re: [PHP] Holding datetimes in a DB.

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