| From: | Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Regarding timezone |
| Date: | 2014-09-10 14:50:00 |
| Message-ID: | CALSLE1MdZa9vUqXNyb7cLaOJKzP3KMw78kxozJHVT5d31t_iiw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
I want to change the timezone to Europe/Moscow. Moscow timezone is changing
from +4 to +3
On the box, I have changed the timezone to MSK+3.
From the db side I have modified the following files:
1) postgresql.conf
timezone = 'Europe/Moscow'
2) pgsql/share/postgresql/timezonesets/Default
MSK 10800 # Moscow Time (caution: this used to mean
10800)
# (Europe/Moscow)
# date
Wed Sep 10 17:34:14 MSK 2014
Running following queries the output is as follows:
- select now() => "2014-09-10 18:34:19.041994+04"
- select now() at time zone 'MSK' => "2014-09-10 17:34:31.006944"
What changes needs to done so that now() returns expected value which
matches with the time zone?
Thanks in advance!
Regards...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2014-09-10 15:13:30 | Re: Regarding timezone |
| Previous Message | Adrian Klaver | 2014-09-10 14:23:40 | Re: stackbuilder |