From: | Vladimir Sitnikov <sitnikov(dot)vladimir(at)gmail(dot)com> |
---|---|
To: | Edson Richter <edsonrichter(at)hotmail(dot)com> |
Cc: | List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Driver behaves differently with prepareThreshold and timestamp fields when daylights is active (was Re: Re: 9.4-1207 behaves differently with server side prepared statements compared to 9.2-1102) |
Date: | 2016-01-11 22:35:00 |
Message-ID: | CAB=Je-HFGbUY-oC0BWB7Y__o1PbO4j_M7eLGRTtNZik+XyFLFA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-jdbc |
Even though the particular case with DATE is fixed, I would still
recommend to consider timestamptz data type.
DATE has inherent timezone problems, so if you are storing time
instants, then you'd better operate on timestamptz.
See "2000-03-26 00:00:00 Atlantic/Azores problem" above.
Vladimir