Re: Can postgresql ignore DST ?
| От | Venkata B Nagothi |
|---|---|
| Тема | Re: Can postgresql ignore DST ? |
| Дата | |
| Msg-id | CAEyp7J80UX2Tm=N=AnNKuhe_s9JqGRDT0EUTgbjaxNVOKcpd0A@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Can postgresql ignore DST ? (Laurenz Albe <laurenz.albe@cybertec.at>) |
| Ответы |
Re: Can postgresql ignore DST ?
Re: Can postgresql ignore DST ? |
| Список | pgsql-general |
On Thu, 14 Dec 2017 at 7:28 pm, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
Venkata B Nagothi wrote:
> On Thu, 14 Dec 2017 at 4:04 pm, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> > Venkata B Nagothi <nag1010@gmail.com> writes:
> > > To rule out any application issues, is it possible to get postgresql to
> > > ignore DST and render all the timestamps with timezone offsets of +11 ?
> >
> > set timezone = 11
>
> We have Timezone configured to Australia/Sydney, we can change that to 11 and do we need to foresee any issues ?
That configuration parameter defines how the client will format
timestamps to strings and vice versa.
It should not have any other effects.
I think what I see is some dates might have changed - is that a possibility ?
If yes, is there any way I can revert back ?
Regards,
Ven
--
Venkata B N
Database Consultant
В списке pgsql-general по дате отправления: