Re: Time Zone design issues

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Ron Johnson" <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Time Zone design issues
Date: 2007-09-11 09:48:22
Message-ID: 87fy1lzg61.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ron Johnson" <ron(dot)l(dot)johnson(at)cox(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Allison 2007-09-11 09:49:50 Re: Debian problem...
Previous Message Phoenix Kiula 2007-09-11 09:47:02 Partial index with regexp not working