Re: [PHP] Time-Zone juggling

2006-11-09 Thread David Giragosian
On 11/9/06, M.Sokolewicz <[EMAIL PROTECTED]> wrote: David Giragosian wrote: > On 11/8/06, Travis Doherty <[EMAIL PROTECTED]> wrote: >> >> David Giragosian wrote: >> >> > Does Daylight Savings alter Zulu time? (I'm guessing "yes"). How did >> the >> > military deal with that? >> > >> > I use a da

Re: [PHP] Time-Zone juggling

2006-11-09 Thread M.Sokolewicz
David Giragosian wrote: On 11/8/06, Travis Doherty <[EMAIL PROTECTED]> wrote: David Giragosian wrote: > Does Daylight Savings alter Zulu time? (I'm guessing "yes"). How did the > military deal with that? > > I use a date-time field as a primary key in db tables that get an > insert a > minut

Re: [PHP] Time-Zone juggling

2006-11-09 Thread David Giragosian
On 11/8/06, Travis Doherty <[EMAIL PROTECTED]> wrote: David Giragosian wrote: > Does Daylight Savings alter Zulu time? (I'm guessing "yes"). How did the > military deal with that? > > I use a date-time field as a primary key in db tables that get an > insert a > minute. I had to jump through a

Re: [PHP] Time-Zone juggling

2006-11-08 Thread Travis Doherty
David Giragosian wrote: > Does Daylight Savings alter Zulu time? (I'm guessing "yes"). How did the > military deal with that? > > I use a date-time field as a primary key in db tables that get an > insert a > minute. I had to jump through a number of hoops to turn off DST on the > (RH > Linux) ser

Re: [PHP] Time-Zone juggling

2006-11-08 Thread tedd
At 9:01 AM -0600 11/8/06, David Giragosian wrote: tedd, Does Daylight Savings alter Zulu time? (I'm guessing "yes"). How did the military deal with that? LOL -- do you think that the military gives a hoot about daylight savings time? That's one of those civilian things. In military time, Oh

Re: [PHP] Time-Zone juggling

2006-11-08 Thread David Giragosian
On 11/8/06, tedd <[EMAIL PROTECTED]> wrote: At 12:48 AM -0500 11/8/06, Travis Doherty wrote: >This can be a big problem to some apps, and others might be fine with >the workaround like we've done where you loose a tiny bit of data (It's >08:00 on the day after the timechange, is this ticket from

Re: [PHP] Time-Zone juggling

2006-11-08 Thread tedd
At 12:48 AM -0500 11/8/06, Travis Doherty wrote: This can be a big problem to some apps, and others might be fine with the workaround like we've done where you loose a tiny bit of data (It's 08:00 on the day after the timechange, is this ticket from 01:30:00 6.5 or 7.5 hours old? who cares.. jus

Re: [PHP] Time-Zone juggling

2006-11-07 Thread Travis Doherty
Richard Lynch wrote: >What is the least-stupid way to fix this, and get 20:00 in the >Portland OR server to turn into: >Mon, 03 Apr 2006 20:00:00 CDT >which is what time it really was. > >E. Without changing the schema which means having to re-do >everything else in the application. That's p

[PHP] Time-Zone juggling

2006-11-07 Thread Richard Lynch
I have a PostgreSQL database chockful of datatype: "time without time zone" The times I chucked in there are, like, '7:00 PM' and they all seem fine... Until I start trying to generate an RFC 882 datetime stamp. :-( At that point, the fact that the server lives in Portland OR, and my times are a