Re: dealing with timezones

2007-12-21 Thread s. isaac dealey
> > Boy unless I'm really confused, it sure sounds like it'd be a > > lot easier for somebody to just spring the $50 for a better cert. > > You typically can't just "spring for a better cert" for internal certs, > which are generated against internal CAs. Within most large organizations > that us

RE: dealing with timezones

2007-12-21 Thread Dave Watts
> Boy unless I'm really confused, it sure sounds like it'd be a > lot easier for somebody to just spring the $50 for a better cert. You typically can't just "spring for a better cert" for internal certs, which are generated against internal CAs. Within most large organizations that use certs for

Re: dealing with timezones

2007-12-21 Thread Aaron Rouse
Certs are made inhouse and that is not going to change. On Dec 20, 2007 8:33 PM, s. isaac dealey <[EMAIL PROTECTED]> wrote: > > As a rule we do not use CF(or the Java it is running on) for TZ > > adjustments. We already have time problems with our CF7 boxes > > because the JVM that adjusts for t

Re: dealing with timezones

2007-12-20 Thread s. isaac dealey
> As a rule we do not use CF(or the Java it is running on) for TZ > adjustments. We already have time problems with our CF7 boxes > because the JVM that adjusts for the TZ changes in the past 1-2 years > conflicts with our LDAPS cert which forces us to run on an older JVM. Boy unless I'm really c

Re: dealing with timezones

2007-12-20 Thread Aaron Rouse
Trust me, the JVM issue has had a lot of man hours invested in trying to fix it and the only solution found was to go to CF8 and that was just more fuel to the people pushing to trashcan CF completely and go to .NET Actually in all reality I do not see us needing to worry about it much since I bel

Re: dealing with timezones

2007-12-20 Thread Paul Hastings
Aaron Rouse wrote: > True, but willing to take the risk. if cf touches any of your datetimes along the way, then you've fallen into tz hell. if your servers are in tz that implement DST scan your cf touched "UTC" datetimes & you won't find *any* on the cusp of DST, they were all rolled into DST

Re: dealing with timezones

2007-12-20 Thread Paul Hastings
Gaulin, Mark wrote: > dreaded daylight savings time shifts, when local time jumps around and > offsets just don't cut it. (My project was CF and java, and most of the why would using offsets not work w/DST changes? if your server's tz isn't UTC then storing datetimes as epoch offsets is probably

Re: dealing with timezones

2007-12-20 Thread Aaron Rouse
True, but willing to take the risk. I actually just had one of our systems adjusted for timezone differences and need to see how he went about it. I know he used the Oracle TZ table and some pointers or data from that table stored in one of the applications tables so that queries could then adjus

RE: dealing with timezones

2007-12-20 Thread Gaulin, Mark
07 3:56 PM To: CF-Talk Subject: dealing with timezones Hey, So I'm thinking of how to deal with timezones. My server's clock is set to US west coast time, and I serve many, many sites that are all in different timezones. They're all running the same code which subscribes (in a fashion)

Re: dealing with timezones

2007-12-19 Thread s. isaac dealey
> Another problem might be if time zone rules change for one area vs > another, didn't this happen recently(past year or so) stateside? We > store the time in GMT and store the offsite needed for the location > the users are at. I don't store offsets for that reason (although I do store the dates

Re: dealing with timezones

2007-12-19 Thread Paul Hastings
Aaron Rouse wrote: > Another problem might be if time zone rules change for one area vs another, > didn't this happen recently(past year or so) stateside? We store the time it happens *all* the time someplace in the world. see: http://www.sustainablegis.com/blog/cfg11n/index.cfm?mode=entry&entry

Re: dealing with timezones

2007-12-19 Thread Aaron Rouse
Another problem might be if time zone rules change for one area vs another, didn't this happen recently(past year or so) stateside? We store the time in GMT and store the offsite needed for the location the users are at. On Dec 19, 2007 5:52 PM, Mik Muller <[EMAIL PROTECTED]> wrote: > Actually,

Re: dealing with timezones

2007-12-19 Thread Mik Muller
Actually, I've had to rethink this position. I just did a search for "INSERT " and "SELECT " in my code and realized that there is an order of magnitude difference in the number of times these statements appear. Don't know why I didn't think about this before, but there's obviously only a singl

Re: dealing with timezones

2007-12-19 Thread Mik Muller
Ok. I decided to not care about server local time offset from GMT, and go only with a server/site offset. A site admin will see what the current server time is and be asked for an offset to that to match their local time. Easy. Now, the next question... when messages are posted, when would be th

dealing with timezones

2007-12-19 Thread Mik Muller
Hey, So I'm thinking of how to deal with timezones. My server's clock is set to US west coast time, and I serve many, many sites that are all in different timezones. They're all running the same code which subscribes (in a fashion) to a central application to verify the site's status. I'm thi