From: | Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Timezone information |
Date: | 2014-02-19 19:59:41 |
Message-ID: | CALSLE1Mh9djWwgGa-35VyXtsQLUzaU0hnE-pq3Q1w=76QdHt8A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wed, Feb 19, 2014 at 8:31 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> If you mean you would like to use Windows' timezone data, the answer is
> you can't --- and you generally shouldn't want to, because AFAIK their
> timezone data is pretty sucky: it's incomplete and not terribly accurate
> about historical details. We use the IANA timezone database[1], which is
> where those names like Asia/Calcutta come from.
>
> Most modern operating systems use the IANA database for their system-level
> timezone knowledge, but Windows is still in the dark ages last I heard.
>
> regards, tom lane
>
Hmm. Is there any postgreSQL command/binary which can be used to set
timezone according to OS one.
At the time of postgreSQL install how does it pick timezone information and
sets into postgreSQL.conf accordingly.
Regards...
From | Date | Subject | |
---|---|---|---|
Next Message | Dev Kumkar | 2014-02-19 20:03:33 | Re: UTF-8 collation on Windows? |
Previous Message | Adrian Klaver | 2014-02-19 19:49:21 | Re: UTF-8 collation on Windows? |