Can postgresql ignore DST ?

From: Venkata B Nagothi <nag1010(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Can postgresql ignore DST ?
Date: 2017-12-14 04:49:19
Message-ID: CAEyp7J9kxG8Gr0sQi42MRTXEeKRc0F6xBD4r5u5fon=_90zSRQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message amul sul 2017-12-14 04:55:27 Re: Can postgresql ignore DST ?
Previous Message Rene Romero Benavides 2017-12-13 23:16:38 Re: pgstattuple free_percent to high