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
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 |