Re: timestamptz, local time in the future, and Don't do it wiki

2023-01-31 Thread Max Nikulin
On 28/01/2023 01:03, Peter J. Holzer wrote: On 2023-01-27 19:12:08 +0700, Max Nikulin wrote: https://wiki.postgresql.org/wiki/Don%27t_Do_This#Date.2FTime_storage Could you, please, add a case when the timestamptz type should not be used? UTC timestamps of forthcoming events may change due

timestamptz, local time in the future, and Don't do it wiki

2023-01-27 Thread Max Nikulin
Hi, I am unsure what is the proper mailing list to discuss an the issue, this one or pgsql-doc. PostgreSQL has a reputation of software with excellent support of time zones, so some people take recommendation to use "timestamp with time zone" type excessively literally. I mean the "Don't do