On Friday, April 6, 2018, David G. Johnston <david.g.johnston@gmail.com> wrote:On Friday, April 6, 2018, PG Bug reporting form <noreply@postgresql.org> wrote:The following bug has been logged on the website: Bug reference: 15145 Logged by: Paj Dib Xyooj Email address: dibxyooj96@gmail.com PostgreSQL version: 9.4.5 Operating system: (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit Description: i set column "document_datenow timestamp with time zone NOT NULL DEFAULT now()" but the values that like this "0001-12-31 23:42:04+06:42:04 BC"What does typing "date" at your o/s command line show?So, that a constant time is used is not unusual, it's documented. Now() is a function that gets resolved at default creation.
On Friday, April 6, 2018, PG Bug reporting form <noreply@postgresql.org> wrote:The following bug has been logged on the website: Bug reference: 15145 Logged by: Paj Dib Xyooj Email address: dibxyooj96@gmail.com PostgreSQL version: 9.4.5 Operating system: (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit Description: i set column "document_datenow timestamp with time zone NOT NULL DEFAULT now()" but the values that like this "0001-12-31 23:42:04+06:42:04 BC"What does typing "date" at your o/s command line show?
The following bug has been logged on the website: Bug reference: 15145 Logged by: Paj Dib Xyooj Email address: dibxyooj96@gmail.com PostgreSQL version: 9.4.5 Operating system: (Ubuntu 4.8.2-19ubuntu1) 4.8.2, 64-bit Description: i set column "document_datenow timestamp with time zone NOT NULL DEFAULT now()" but the values that like this "0001-12-31 23:42:04+06:42:04 BC"
pgsql-bugs by date:
Соглашаюсь с условиями обработки персональных данных
