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 <nag1010@xxxxxxxxx> wrote: > 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 timezone offsets as +10 and +11 > depending on the date, time etc. Upon querying Oracle, i get all the > timezone offsets as +11, adding to this, making the application code > compatible to this will be utterly complex. > 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 ? > > I know it is weird question and it is not the right thing to do on the > database, i am just asking in-case we may bump into this requirement in the > near future. > > Any advise is appreciated ! > > > > Regards, > Venkata B N >
