Re: Time Zone design issues - Mailing list pgsql-general

From Gregory Stark
Subject Re: Time Zone design issues
Date
Msg-id 87fy1lzg61.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Time Zone design issues  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: Time Zone design issues  (Steve Atkins <steve@blighty.com>)
List pgsql-general
"Ron Johnson" <ron.l.johnson@cox.net> writes:

> On 09/10/07 19:50, Tom Lane wrote:
>
>> This whole sub-thread actually is predicated on an assumption not
>> in evidence, which is that there is any browser anywhere that will
>> tell the http server timezone information.  I'm quite sure no such
>> thing is required by the http standard.
>
> I'm really surprised.

I think all you get is the localized language. If it's localized to a
particular country then that might be good enough for a guess from some
countries but there's not much you can do with en_US or ru_RU.

I think most big commercial sites that decide they need this just buy access
to one of the ip to geographic location services which are far from perfect
but in my experience are plenty good enough to get a reasonable time zone.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

pgsql-general by date:

Previous
From: "Phoenix Kiula"
Date:
Subject: Partial index with regexp not working
Next
From: Tom Allison
Date:
Subject: Re: Debian problem...