Re: Can postgresql ignore DST ?

On Fri, Dec 15, 2017 at 6:21 PM, Laurenz Albe wrote: > Venkata B Nagothi wrote: > > > > 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

Re: Can postgresql ignore DST ?

On Thu, 14 Dec 2017 at 7:28 pm, Laurenz Albe wrote: > Venkata B Nagothi wrote: > > On Thu, 14 Dec 2017 at 4:04 pm, Tom Lane wrote: > > > Venkata B Nagothi writes: > > > > To rule out any application issues, is it possible to get

Re: Can postgresql ignore DST ?

Venkata B Nagothi wrote: > On Thu, 14 Dec 2017 at 4:04 pm, Tom Lane wrote: > > Venkata B Nagothi 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

Re: Can postgresql ignore DST ?

. Do Regards, Ven On Thu, 14 Dec 2017 at 4:04 pm, Tom Lane wrote: > Venkata B Nagothi 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

Re: Can postgresql ignore DST ?

Venkata B Nagothi 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 regards, tom lane

Re: Can postgresql ignore DST ?

How about storing timestamp without timezone[1]? 1] https://www.postgresql.org/docs/current/static/datatype-datetime.html Regards, Amul On Thu, Dec 14, 2017 at 10:19 AM, Venkata B Nagothi wrote: > Hi All, > > I have a question regarding PostgreSQL time zones and daylight

Can postgresql ignore DST ?

Hi All, I have a question regarding PostgreSQL time zones and daylight savings - We have been migrating Oracle databases to PostgreSQL and the database we are migrating from does not seem to follow daylight savings and it is good that postgresql does. When i query the date columns i get the