Re: Timezone information
| От | Dev Kumkar |
|---|---|
| Тема | Re: Timezone information |
| Дата | |
| Msg-id | CALSLE1OpRcOwdKV_Gy+=J++rrQErhPzPmPLV2fOJy3+CQhvL-w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Timezone information (Andrew Sullivan <ajs@crankycanuck.ca>) |
| Ответы |
Re: Timezone information
Re: Timezone information |
| Список | pgsql-general |
On Thu, Feb 20, 2014 at 2:32 AM, Andrew Sullivan <ajs@crankycanuck.ca> wrote:
Try issuing SET TimeZone commands. I think you'll find that the
client can set whatever time zone it wants.
I think am not being heard incorrectly here.
Here is the scenario - Database is created using binaries and not postgreSQL installer here. Next this database gets created on one machine SRC-INDIA and then is shipped globally which can be in any timezone, for example TGT-USA.
Since the database is created on SRC-INDIA the timezone parameter gets set as "Asia/Calcutta", but when shipped locally then now() would return incorrect time as per target TGT-USA local time.
Regards...
В списке pgsql-general по дате отправления: