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 !