Re: DateConvert Bug

2006-09-09 Thread Rick Root
Paul Hastings wrote: i could have sworn peter blogged about this but in any case, from back in may I googled his web site and his blog for dateConvert and didn't find it. Ah well... is it specific to the date you mentioned, the day of spring forward (and fall back)? Rick

Re: DateConvert Bug

2006-09-09 Thread Paul Hastings
Rick Root wrote: I googled his web site and his blog for dateConvert and didn't find it. must have been from email or whatever. peter's put more thought into the dateconvert issue than i have maybe he will chime in. i'm more concerned about cf datetimes in general as i said in my blog, i'd

Re: DateConvert Bug

2006-09-09 Thread Rick Root
Paul Hastings wrote: that's for one US tz. globally there are plenty of others that follow DST and these are often a moving target. a recent for instance, australia DST normally ends march 26, 2:59AM (local time) but got pushed back to april 2nd to accommodate TV coverage of some

Re: DateConvert Bug

2006-09-09 Thread Peter J . Farrell
i could have sworn peter blogged about this but in any case, from back in may No Paul, remember we had a big email discussion over a period of days about. I thought I may have blogged it, but I didn't unfortunately. Maybe I'll blog it now...

Re: DateConvert Bug

2006-09-09 Thread Rick Root
Peter J. Farrell wrote: i could have sworn peter blogged about this but in any case, from back in may No Paul, remember we had a big email discussion over a period of days about. I thought I may have blogged it, but I didn't unfortunately. Maybe I'll blog it now... At the very

Re: DateConvert Bug

2006-09-09 Thread Paul Hastings
Peter J. Farrell wrote: i could have sworn peter blogged about this but in any case, from back in may No Paul, remember we had a big email discussion over a period of days about. I thought I may have blogged it, but I didn't unfortunately. Maybe I'll blog it now... age + dumping my

Re: DateConvert Bug

2006-09-09 Thread Paul Hastings
Rick Root wrote: Partially yeah... I suppose if you KNEW your server was in a specific timezone with a consistent DST, you could correct for it, but that stuff always changes, next year the US will implement DST changes. and you really don't want to track global changes (there are more

DateConvert Bug

2006-09-08 Thread Rick Root
Related to our previous discussion... I can't find the details about the DateConvert bug that Paul Hastings referred to, though I find numerous references to it. What exactly is the issue? Currently, my server time is in EDT. I'm inserting dates in UTC time into the database using

Re: DateConvert Bug

2006-09-08 Thread Rick Root
Paul Hasting's suggesting from the other thread seems to work But I'm still interested in the specifics of this bug.. if anyone knows *WHEN* dateConvert() does not work...I'd love to know. Rick ~| Introducing the Fusion

Re: DateConvert Bug

2006-09-08 Thread Paul Hastings
Rick Root wrote: Paul Hasting's suggesting from the other thread seems to work was there any doubt ;-) But I'm still interested in the specifics of this bug.. if anyone knows *WHEN* dateConvert() does not work...I'd love to know. i could have sworn peter blogged about this but in any case,