On Thu, 14 Dec 2017 at 7:28 pm, Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote:
Venkata B Nagothi wrote:
> On Thu, 14 Dec 2017 at 4:04 pm, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
> > Venkata B Nagothi <nag1010@xxxxxxxxx> 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
