On Thu, 14 Dec 2017 at 7:28 pm, Laurenz Albe <laurenz.a...@cybertec.at> wrote:
> Venkata B Nagothi wrote: > > On Thu, 14 Dec 2017 at 4:04 pm, Tom Lane <t...@sss.pgh.pa.us> wrote: > > > Venkata B Nagothi <nag1...@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 > -- Regards, Venkata B N Database Consultant
