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

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 minute. I had

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 date-time field as a primary

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

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 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 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) server.

[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

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