Re: Timezone information
От | Tom Lane |
---|---|
Тема | Re: Timezone information |
Дата | |
Msg-id | 31467.1392822112@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Timezone information (Dev Kumkar <devdas.kumkar@gmail.com>) |
Ответы |
Re: Timezone information
|
Список | pgsql-general |
Dev Kumkar <devdas.kumkar@gmail.com> writes: > How to set timezone in postgreSQL database to pick operating system level > timezone information. 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 [1] http://www.iana.org/time-zones
В списке pgsql-general по дате отправления: