From: | amul sul <sulamul(at)gmail(dot)com> |
---|---|
To: | Venkata B Nagothi <nag1010(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Can postgresql ignore DST ? |
Date: | 2017-12-14 04:55:27 |
Message-ID: | CAAJ_b96LLLVJfPROvpm_aFD159HnJMC8pg=HqAUiEaafYxSwMQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)gmail(dot)com> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2017-12-14 05:04:56 | Re: Can postgresql ignore DST ? |
Previous Message | Venkata B Nagothi | 2017-12-14 04:49:19 | Can postgresql ignore DST ? |